This content has been marked as final. Show 2 replies
I want to compare a column A with values, say value A to all possible values from column B, eventhough they are not related in the same row.
|Column A||Column B|
For this example I want to compare COUNT(IF(Column B <> All possible values of Column A, 1)) This should result in 4.
I cannot find the syntax to compare to unrelated values.