I know nothing about Excel, so the first thing I would like to do is to remove any duplicates from within the lists themselves.
But then I would also like any rows from list B that has a duplicate row in list A to be removed.
For example, if the email
John@John.com is in list B and there is also a
John@john.com in list A, I want to remove
John@john.com from list B.