I have 2 lists of names:
use:
=FILTER(A2:A, NOT(COUNTIF(B2:B, A2:A)))
755k questions
754k answers
5 comments
53.3k users