Previous Topic Next Topic

Comparing Two Sheets in Excel to Eliminate Date

Closed
JuliaBlair Posts 1 Registration date Wednesday December 9, 2015 Status Member Last seen December 9, 2015 - Dec 9, 2015 at 06:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 15, 2015 at 04:04 PM
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

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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses