I need an Excel macro which will de-dupe a column of data?

[JPAuctions]

I periodically have columns of addresses and when I add new members, I
need to check for duplicates. I could use FInd for each new address/name, but
the add-on names/addresses are numerous.

Any simple macros to de-dupe a column.

Thanks
Joe
ipAuctions, Inc.

 

[Gord Dibben]

Macro not required.

You can flag for duplicates as you enter new names/addresses or delete the
duplicates after the fact by using Data>Filter>Advanced Filter.

Check "unique records" and "Copy to another location".

For flagging see Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

For more on Advanced Filter see Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP