Merge and remove duplicates?

[Shanel]

I have a new workbook and an old workbook with contact information. How can
I merge the two workbooks removing duplicate entries?

 

[Gaurav]

I guess you will need to give some more info.