How to remove both duplicate and corresponding cells

Hello,

I haven't been able to find a solution to this problem I'm having. I have two lists of emails (one with first name, last name, and email; the other with just email).

When merged together, one shows a list of all of my customers, the other shows an email list of customers that currently own my product. I want remove the emails of the customers that own the product, and remove them from the original list (please see attached).

My problem is that I can easily remove the duplicate emails, but can't figure out how to also delete the row with their first name, last name, and email (without spending a great deal of time doing this manually).

Any help would be greatly appreciated. Thank you!

Adam