Clarification needed if possible.
Whats the difference between the expressions CONTAIN and IN?
I am looking for the function to search for a word in a column, but it may be part of several words in a list.
Thanks in advance.
@geoff_gardener In a list of: {โThis is Geoffโ, โtest1โ}
IN(โGeoffโ,LIST(โThis is Geoffโ, โtest1โ)) returns FALSE
however
CONTAINS(LIST(โThis is Geoffโ, โtest1โ),โGeoffโ) returns TRUE
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |