Deleting duplicates in different columns

[callardt]

Hi,

Basically I have a list of 16,000 email addresses. I then have a separate list of 5,000, all of which don't work. What I need to do is delete any email address in the large list which appears in the small list. Deleting duplicates doesn't work. I can't think of a way of doing it other than going through and individually deleting email address.

Help please.
t

[arthurbr]

Hi and welcome to the board.
CPearson has a solution here
under Extracting Elements From One List Not On Another List

Cheers

[callardt]

Brilliant. Thankyou.