Microsoft Office Questions? Ask a IT Expert for Support ASAP
If by email you mean "email addresses", please put the two lists in the same workbook and attach the file here so I can setup the formulas for you
Ok go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Got it. So you want he duplicates to be removed from the shorter list on the right and not from the longer list on the left, correct?
Ok, uploading the file, one moment...
Ok here you go
The formulas in the yellow column returns X next to the email where a duplicate is found. After identifying all the duplicates I copied the data to the next sheet 'Final' and deleted those that have X's
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
Sure, one moment please..
In cell D1 the formula
does the following
first, this part
looks in the range A1:A5437 for any occurrence of the email in cell C1
If found, that countif will count as 1. If not found it will return 0
So the entire formula is:
if the count is greater than 0 then put an "X", otherwise leave the cell in D blank
Hope this helps
Thanks in advance for accept and feedback (bonus would also be great)
Please go ahead and accept and pay bonus while I review your last question
Ok what I did was copy columns C and D and paste them on the second sheet using Paste Special > Values.
Then I sorted the list on column E so all the X's will be grouped together, then I deleted that group