Exclusion Filter?

[ct711]

I am working with large email lists from previous years of an event. I would like to create a single list that contains the emails from all previous registrants, however, I do not want the list to contain an email address if it has already been used for registration this year (essentially a list of all previous registrants that haven't signed-up for this year).

My current excel file has the list of all previous registrant emails in one column (one email per row) and all the current year email addresses in the second column.

Is there a way for me to have excel remove all emails from column A that are present in column B?

Thanks

[NBVC]

Cut and paste column B list to another sheet, say Sheet2, column A

Then back in original sheet enter formula in B2:

=Isnumber(Match(A2,'Sheet2'!A:A,0))

copied down

Then go to Data|AutoFilter

and filter column B for TRUE

delete these rows, and then remove the filter and delete column B

You should be left with emails that are not in the Sheet2, column A list.