I have 3 Excel files, each have thousands of email contacts. I would like to identify and delete any duplicates between the 3 files / lists of emails.
Any advice for doing this?
MY guess is the best way would be to move all lists to 1 Excel file and each list is in its own separate tab...call each tab list 1, list 2, list 3...and run some sort of formula that checks / identifies / deletes any duplicates...would a 'vlookup' formula work here? Perhaps a 'match' formula?
Thanks!
Dom
Bookmarks