how do you de-dup an address list in Excel?

  • Thread starter Thread starter Jim Agnew -- Canada
  • Start date Start date
J

Jim Agnew -- Canada

I'm trying to automate the deduplication of an address list in Excel.
 
Hi

Look at the "Advanced Filter" on the data menu and select "unique only".

Hopes this helps
 
Hi,

In 2007 choose the list and then the command Data, Remove Duplicates - a
nice new feature!

In 2003 use advanced filter as mentioned in the previous post, then select
the results and copy them somewhere else. The delete the original list.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dup check 2 columns - need it to delete correct one 5
How do I find dups across different columns 1
X Factor into Percent... 3
Excel Function Help please 3
Using EXACT to Deduplicate 4
list duplicates 2
deduplicate data in excel 8
Not just remove dup rows but combine columns 1

Back
Top