Merge two spreadsheets with names database then search for duplica

G

Guest

I have two mailing data bases with names; I want to merge them into one
spreadsheet, then check for duplicates.

Any ideas?
 
G

Gord Dibben

Copy both databases to one Excel worksheet preferably in the same column(s).

Then the massaging starts.

What do you want to do with duplicates if/when found?

Keep one of each and delete the extras?
Use Advanced filter and check "unique records" and "copy to another place"
See Debra Dalgleish's site for more on this.
http://www.contextures.on.ca/xladvfilter01.html

Tag them so you know which are duplicates and hide them?
See Chip Pearson's site for tagging and highlighting duplicates
http://www.cpearson.com/excel/duplicat.htm


Gord Dibben MS Excel MVP
 

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

merging spreadsheets 2
I want to combine 2 workbook data bases and remove duplicates 1
Merging Spreadsheets and Finding Matches and Exceptions 3
How do I match and append/merge data from two spreadsheets? 2
merging two large spreadsheets 2
Identify Duplicates that are not identical 4
reverse mailing list? 2
Spilting a column 6

Top