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

X Factor into Percent... 3
Dup check 2 columns - need it to delete correct one 5
Excel Function Help please 3
How do I find dups across different columns 1
ETL tool in foreign languages 4
Is de-duping in advanced filter limited to a number of rows 2
Count if one cell has a name in it and another column does not 2
Duplicate Entries 1

Top