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

  • Thread starter Thread starter Jonathan6315
  • Start date Start date
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??
 
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
 
If you are using Excel 2007 you can use the 'Remove Duplicates' button on the
Data ribbon.

Hope this helps,

Hutch
 

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

Duplicate Find not finding all dupes 3
I need an Excel macro which will de-dupe a column of data? 1
Does anyone know of any 'Smart' Duplicate Remover? 1
Customer DB Duplicates 3
Making the AND function look at only part of a cell entry 2
Trouble Finding Duplicate Values with Conditional Formatting 2
how can i de-dupe email lists using excel? 1
Multiple column and row duplicate problem 2

Back
Top