Duplicate Checking in Excel

[anthony]

Good afternoon. I have always used a script which would
look for duplicate entries in a column in excel, but have
lost it due to hardware failure without a backup. What I
used to do was create a new macro and paste the script
into the VB editor.

For it to run, I would need to have my column sorted
ascending and trimmed and it would highlight the
duplicates in that column. Can anyone help me in doing
this same thing or point me in the right direction? I
need the duplicate entries highlighted, not deleted

 

[Tom Ogilvy]

You might find some more robust approaches on Chip Pearson's site:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

some don't even require a macro.

 

[Anthony]

Thank you very much. this will do just as well.

-----Original Message-----
You might find some more robust approaches on Chip Pearson's site:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDu plicates

some don't even require a macro.

--
Regards,
Tom Ogilvy





.