I am combining contact records from 2 different xls worksheets and need to
delete the duplicates. I need to know how to -
1. identify the duplicates [Assuming column A contains last name and column
B first name, I have done this through =IF((A2=A1)*(B2=B1), "duplicate", "")
but dont know if there is a better way :-)]
2. tranfer any missing information from duplicate to the reference record
[additional information in columns C-Z]
3. Delete the duplicate record

Thank you!