Macro to Find Duplicate Cells within a Column

[Marisel]

How do I create a macro to find duplicate entries within
a column? I have a column filled with addresses, and I
want to delete duplicate addresses.

Thanks!

 

[Frank Kabel]

Hi Marisel
have a look at
http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

HTH
Frank

 

[Gord Dibben]

You don't need a macro, but if you want one, record one while following the
steps outlined on Debra Daleish's site.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP