Duplicate checking

**JoshJ** · 08-29-2013, 09:37 AM

Hey guys,

I have a workbook with a list of new contacts in one sheet, and a list of old contacts on another sheet.
I want to run a duplicate check throughout the workbook to highlight and delete any contacts on my new list, that have already been contacted on my old list.
Also, I need the the duplicate checker to check for non specific names, regardless of punctuation, upper/lower case, etc.
I need to to highlight all of the following variations as possible duplicates which i can then review & delete manually;
Apple Corp,
Apple Ltd
APPLE LTD
Apple.com
etc...

Does anyone know what I can use to do this?

**L-Drr** · 08-29-2013, 02:30 PM

This is probably not a 100% logical problem that can be fully translated into formulas that excel understands, so parts of your problem (at least the removing part) will have to be solved manually.
To search for cells that contain "apple", use

=ISERROR(FIND("apple",A1))

and drag down. the FALSEs are cells with apples in them. how do you like them apples?

**JoshJ** · 12-09-2013, 01:12 PM

Hi L-Drr. Thanks for your reply. I am still trying to get to the bottom of this problem;

How can I use your above formula to automatically highlight ALL duplicate values on a sheet, even it the name is not "apple"

**FDibbins** · 12-09-2013, 06:46 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.