Suppose you have two lists:

a, b, c, d, e, f, g

and
a, b, e, g

and you want to extract only the items on the first list that are not on
the second list.

I tried =IF(A1<>$B1:$B8,A1)

and also

{=IF(A1<>$B1:$B8,A1)}

neither worked, any suggestions?

Thanks,
Les