My filter function is almost there, but not quite. I want to display only those rows
in List1
one that are not in List2
, based on the email column
(c). This works without the NOT
and it displays only the matches, so of course I need to add a NOT
to display only those that do not match.
Here is my almost working filter thus far. I am getting an error with this though, from adding the NOT
. How do I fix it?
=filter(List1!A2:D199, NOT(match(List1!C2:C199,List2!C1:C11, 0)))