How do I remove duplicate emails from a list?

**fastrack1** · 01-21-2010, 10:06 PM

I have a master list of about 16,000 emails in Excel, but some are duplicates. Is there a formula to remove the duplicates? Any help would be appreciated

**teylyn** · 01-21-2010, 10:16 PM

You can have a look at Advanced Filter, where you can filter a list for unique records only.

If you post a file with a few dozen rows containing some duplicates, we can show you how. Just make sure you use fake names and addresses.

**fastrack1** · 01-21-2010, 10:31 PM

Originally Posted by teylyn

You can have a look at Advanced Filter, where you can filter a list for unique records only.

If you post a file with a few dozen rows containing some duplicates, we can show you how. Just make sure you use fake names and addresses.

Here is a file with duplicates. Thanks for the help.