Comparing Two Sheets in Excel to Eliminate Date

[Closed]
Report
Posts
1
Registration date
Wednesday December 9, 2015
Status
Member
Last seen
December 9, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
one way would be to use match function and then apply filter to delete rows where there is no match