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

[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?

[mrice]

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

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