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 |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |