Right, I'm at work trying to remove duplicate contacts from a couple of Excel sheets. Each sheet has things like email address, first name, last name fields. I want to make sure that there is no contact on both of the two sheets.
I had tried to do it by copying and pasting all the email addresses into a new sheet, and then using the "unique function" filter to cut out the duplicates. However, I then run into the problem of re-matching the email addresses to the original lines and the rest of the contact details; there are a few thousand so I don't want to be doing this manually.
Any help would be much appreciated!
I had tried to do it by copying and pasting all the email addresses into a new sheet, and then using the "unique function" filter to cut out the duplicates. However, I then run into the problem of re-matching the email addresses to the original lines and the rest of the contact details; there are a few thousand so I don't want to be doing this manually.
Any help would be much appreciated!