My filter function is almost there, but not quite. I want to display only those
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)))