Checking two lists for duplicates

[etrader58]

I have two email lists. First as a single column list of emails, and I created the second one as Name (column A) and email (column B). These are as separate files or sheets. How I can check for duplicate emails between two lists? I want to delete the row in the second list, if the email exists in the first list.

Thanks

 

[RichardMGreen]

Can you post some samples (test data rather than proper email addresses).
It should be straight forward enough, but some samples would just make life easier.

 

[etrader58]

Thanks for your kind attention. It loosk like

First List:
Column A
some@example.com
second@web.com
someone@domain.com


Second List:
Column A | Column B
John Smith | john@example.com
George | george@web.com
Someone | someone@domain.com
Some | some@example.com

As a matter of fact, I have sent emails to the first list; now I created the second list, and I want to avoid sending email to any person in the first list again.

 

[Sanjeev1976]

Use a vlookup formula in Column C in the Second list and it would give you all the identical email id's in First list. Then filter the list with available email id's and delete them to get unique email id's not existing in First list.

 

[RichardMGreen]

I was going to do something along the lines of a countif, but it would give you a similar outcome.