Previous Topic Next Topic

Comparing Two Sheets in Excel to Eliminate Date

Closed
JuliaBlair Posts 1 Registration date Wednesday 9 December 2015 Status Member Last seen 9 December 2015 - 9 Dec 2015 à 18:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Dec 2015 à 16:04
I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the two lists so that when I'm done, only data that isn't on the second list will be left on the first?

Thanks!
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Dec 2015 à 16:04
one way would be to use match function and then apply filter to delete rows where there is no match

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses