Macro to search for duplicates

**aharvestofhealth** · 04-21-2009, 03:03 PM

Is it possible to use a macro to first highlight the duplicates in a column and then second to use the find and replace function to skip down the column to find each one. The duplicates will be UPC codes in a single column that will be "numbers stored as text". I would like the macro to search all of the column (Column Q for example), then highlight and find each duplicate.

**mrice** · 04-21-2009, 03:13 PM

What do you want the macro to do when it has found the duplicates?

A simple way of highlighting duplicates in Excel 2007 is to use conditional formatting - see the options under 'New rules'

**c.vaibhav** · 04-21-2009, 03:22 PM

You can also use VBA Macro to do the same,

The following macro will search for duplicate entries and except for the original (will be chosen based on the position) this macro will colour all the entries that matches the original..

Please Login or Register  to view this content.

Instead refer to the attached file where on running the macro all the unique entries are displayed.

**aharvestofhealth** · 04-21-2009, 04:24 PM

Ok, let me try to explain it a little differently. I used the Conditional Formatting function to find all duplicate values in column Q. That works fine. Next I try to go to the first duplicate value by using the Find and Replace. That is where it does NOT work.

Finally, I would like to wrap this all up and place it into a macro. So that the macro would prompt me to continue after finding each duplicate. (See image below for example)