Merging two excel files

  • Thread starter Thread starter SPARKLYSCOTTY
  • Start date Start date
S

SPARKLYSCOTTY

Hi folks. I have two mailling lists that I would like to turn into one.
Is there a way to merge the data where duplicate entries are
automatically found and removed?
Thanks! :confused:
 
Copy both lists onto one worksheet. Then, Chip Pearson has information
on finding and tagging duplicate entries in a list.

http://www.cpearson.com/excel/duplicat.htm

After you've tagged them, use an AutoFilter to filter them, and delete
the visible rows. Or, sort by the Tag column, and delete the duplicates.
 
You must log in or register to reply here.

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

Best solution to merge multiple Outlook contacts easily 2
sorting two columns of merged cells 1
Mail Merge (Excel to Excel) 1
Merging data from 2 data excel sheets 2
Mail merge in Excel 1
Merging data lists - PLEASE HELP!! 2
anyone know if it'spossible to de-dupe a mailing list using excel 3
Merging the Changes from One Excel Document into another 9

Back
Top