I have 2 lists. The first is a list of emails that has all the emails I've compiled for a subscriber list. The other list has most of the names but I know some are missing from the list. I just don't know which emails are missing. To find out which emails are missing, I've taken the emails from both lists and put them in excel. Now, I need to find a way to remove the duplicate emails so that the non-duplicate emails will remain and I'll be able to tell which emails are missing from the 2nd list. However, to do this, I need to remove both sets of duplicate data. This means, if there are 2 same email addresses in the list, I want to delete both of them instead of just the 1 duplicate. Thoughts?