I have 2 lists of email addresses and I want them to match up

S

sgolland

Hi,

I have two serperate columns of email addresses and I basically need t
delete the ones that appear in column B from Column A but I do not hav
the time to sit and go through column A one by one looking for them an
deleting them as I find them. Is there a way that I can match the emai
addresses of column B so that they go to the cell in which the matchin
email address will be next to it in column A?
Hope this all makes sense!.

ps thank you very much to anyone who helps me! I am very grateful as i
will save me so much time
 
M

Miguel Zapico

You may use an additional column with a formula like:
=COUNTIF($A$1:$A$1000,B1)
This will be greater than 0 if the email in B1 is present in the first 1000
rows of column A, and 0 otherwise. You can drag the formula all along column
B, and then filter, or sort/delete, on values with a 0 on column C

Hope this helps,
Miguel.
 
Top