Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for checking duplicate entries | Excel Worksheet Functions | |||
Checking for duplicate entries | Excel Discussion (Misc queries) | |||
Checking for duplicate items in list | Excel Worksheet Functions | |||
Checking for duplicate data | Excel Programming | |||
checking for duplicate worksheets | Excel Programming |