Forum Discussion
Using the FILTER Function
I have a spreadsheet with a long list that I need to search to determine if a specific word or term is included in the list. In some cases, I want to search for part of the word or term, e.g., I may...
Since you have FILTER you may well have the REGEX functions.
Worksheet formula
= FILTER(list, REGEXTEST(list, term))The above will examine each member of the 'list' to determine whether it contains a match for the 'term'.
To cater for missing terms requires the [if_empty] optional parameter to be provided
Worksheet formula
= FILTER(list, REGEXTEST(list, term), "Not present")