Compare entries in 2 worksheets and list what does not match

  • Thread starter Thread starter The Chomp
  • Start date Start date
T

The Chomp

Good Day All;

I have 2 Excell works sheets with approx 14000 rows each. What I would like
to do is compare both lists and get a 3rd list that shows what entries do not
match.
Is there a simple way to do ythis in Excel

Thanks All
Chomp
 
Assuming A1 should equal A1 in the other sheet...

=IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1)

Auto-Filter for non-blanks.
 
Thank you very much Luke

Luke M said:
Assuming A1 should equal A1 in the other sheet...

=IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1)

Auto-Filter for non-blanks.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Back
Top