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

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.

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

Macro not required.

You can flag for duplicates as you enter new names/addresses or delete the
duplicates after the fact by using DataFilterAdvanced 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

On Tue, 18 Jul 2006 07:35:02 -0700, JPAuctions
wrote:

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.