Comparing cell sheets

Closed
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,
I'm in a dilema. I have two excell sheets with data information.

Both sheets contact customer name, address, and phone numbers.

I need to cross referance about 2200 name to find duplicates.

How would I be able to cross refferance two different excell sheets for same infomation (look for duplicates)

thank you all very much

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
Have a read here, it may shed some light on your problem
https://www.mrexcel.com/excel-tips/duplicates-with-conditional-formatting/

have a look here also, it mentions your problem of more than 1 sheet.
http://www.computing.net/answers/office/excel-highlight-duplicate-entries/5159.html