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!

Comparing Two Sheets in Excel to Eliminate Date
Excel macro compare two sheets and highlight differences ✓ - Forum - Excel
Excel compare two sheets - Guide
Copy data from one excel sheet to another: automatically - Guide
Comparing data between two excel sheets ✓ - Forum - Excel
Comparing values of two Excel sheets ✓ - Forum - Excel

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!