Hi,

I have two serperate columns of email addresses and I basically need to delete the ones that appear in column B from Column A but I do not have the time to sit and go through column A one by one looking for them and deleting them as I find them. Is there a way that I can match the email addresses of column B so that they go to the cell in which the matching 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 it will save me so much time!

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.

"sgolland" wrote:


Hi,

I have two serperate columns of email addresses and I basically need to
delete the ones that appear in column B from Column A but I do not have
the time to sit and go through column A one by one looking for them and
deleting them as I find them. Is there a way that I can match the email
addresses of column B so that they go to the cell in which the matching
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 it
will save me so much time!


--
sgolland