Previous Topic Next Topic

Comparing cell sheets

Closed
Zeppy - Dec 11, 2009 at 08:53 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Dec 11, 2009 at 02:13 PM
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 response

Answer 1 / 1
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Dec 11, 2009 at 02:13 PM
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response