I want to make an expression that gives me the following
{"a", "a", "a"} = TRUE (ie: every element in the list must be "a")
{"a", "a", "b"} = FALSE (contains something other than "a")
{"a", "b", "c"} = FALSE (contains something other than "a")
In other words, I want an expression that checks the list contains anything other than "a", then apply NOT() to the expression. I thought of NOT(CONTAINS(...)), but that is not correct.
Solved! Go to Solution.
https://support.google.com/appsheet/answer/10107963?sjid=12360751839617977796-AP
COUNT(INTERSECT({list},{list}) ) should return one if there is only one unique element and more than one otherwise.
User | Count |
---|---|
15 | |
11 | |
7 | |
3 | |
2 |