How do I merge 2 data bases in Excel avoiding duplicate records?

H

Harrison

Have two files of records. Want to merge but avoid ending up with two of the
same records in the combined database. Is there way to do this without
alphabetizing and visually scanning for duplicates?
 
M

mrice

You might want to try allowing duplicate records to be imported and the
removing the duplicates.

An easy way to do this is using the Data-Advanced filter setting a
empty criteria range and setting the unique records flag to true
 
Top