Need Macros to find and list duplicates in a column

[Karthik Sen]

Hi All,

I need a macro which finds and lists the duplicate values in a given column.
I am attaching the excel sheet for your reference.

[bheanloh]

Try

Please Login or Register  to view this content.

[benishiryo]

hi , you can actually do Conditional Formatting to highlight those duplicates by selecting A1:A10 & going to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=COUNTIF($A$2:$A$10,A2)>1.

but if you need to list them, try:

Please Login or Register  to view this content.

[Karthik Sen]

Thanks a lot for the solution, however instead of coloring the duplicate values, is it possible to show the "Duplicate Values" in a Msgbox.

[benishiryo]

how about:

Please Login or Register  to view this content.

[Marcol]

Do you really need a macro for this?

This workbook will update as the Data in Column A Grows.

The helper column can be hidden.

The C/F highlights the duplicates

[EDIT]
Extracted more information using formule, and changed workbook.

[bheanloh]

If you want a macro, try this

Please Login or Register  to view this content.