Duplicate Checking in Excel
 

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

Duplicate Checking in Excel
 

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

http://www.cpearson.com/excel/duplic...tingDuplicates

some don't even require a macro.

--
Regards,
Tom Ogilvy


"anthony" wrote in message
...
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

Duplicate Checking in Excel
 

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/duplic...HighlightingDu
plicates

some don't even require a macro.

--
Regards,
Tom Ogilvy


"anthony" wrote in message
...
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


.