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

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

Per Jessen

Hi

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

Hopes this helps
 
S

Shane Devenshire

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.
 

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

Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Drop down list control value in vba 2
Outlook calendar list 0
Dup check 2 columns - need it to delete correct one 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
How do I find dups across different columns 3
How to make repeating drop-down lists? 2

Top