Compare entries in 2 worksheets and list what does not match
Thank you very much Luke
"Luke M" wrote:
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!*
"The Chomp" wrote:
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
|