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

Comparing cell sheets
If cell contains text then return value multiple conditions ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Conditional formatting if cell contains text - Excel Forum
Google sheets rtl - Guide
Excel: If Date =, then enter a value ✓ - Excel Forum

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

Counting cells containing only numbers

Comparing columns and returning value

help me to add particular cells

If a cell contains any text then add a value

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!