Editing a long list to avoid duplicates

[Cam11]

Hello!

I have one list (List 1) of about 4,000 names, and another list (List 2) of ~300 names. I am sending out 2 letters and want to avoid duplicates. If there are any List 2 names on List 1, I want to remove them from List 1. The problem is that only some names are duplicated, and I'm trying to avoid doing the search manually.

I've attached an example workbook in case someone can explain a function with it.

Thank you!

[ChemistB]

In B2 of List 1 copied down

=IF(ISNUMBER(MATCH(A2, 'List 2'!$A$3:$A$8,0)),"Delete","")

Then filter on "Delete" and delete those rows
Does that work for you?

[Cam11]

That looks great. Thanks!