MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Remove dupliacte info

Posted by Brendon Sinclair on November 09, 2001 6:09 PM


Thanks for the previous answer.

I have a large list of e-mail addresses in an Excel file - one e-mail address per row.

I've noticed that many e-mail addresses are duplicates - is there a way to remove duplicated addresses automatically?



Posted by bob umlas on November 09, 2001 7:14 PM

use Data/Filter/Advanced Filter and click Unique entries as well as copy to another location, then copy/paste this new location into the original.