Compare entries in 2 worksheets and list what does not match
 

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

Compare entries in 2 worksheets and list what does not match
 

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

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