anyone know if it'spossible to de-dupe a mailing list using excel

J

Jonathan6315

Hi I've merged 2 mailing list files and have noticed there are a few
duplicate records.Is there a way of de-duping in Excel??
 
J

Jacob Skaria

Check out this option.

--Select data range and from menu Data>Filter>Advanced Filter>Copy to
another location..
--In 'copy to' select a cell and check 'Unique records only'
--Click OK ..will give you the unique list
 
T

Tom Hutchins

If you are using Excel 2007 you can use the 'Remove Duplicates' button on the
Data ribbon.

Hope this helps,

Hutch
 
Top