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
Sheets right to left - Guide
Excel compare two sheets - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
An example of a cell is a blank cell ✓ - Programming Forum
If cell contains date then return 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

help me to add particular cells

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

Counting cells containing only numbers

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!