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
4479
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!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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