Merge two spreadsheets with names database then search for duplica

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Any ideas?
 
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
 
Back
Top