Forum Discussion
Solved
Can I use wildcards with the new FILTER function
I want to be able to filter a list that contains cells with lengthy text strings in them such as "12:15 to 12:35 Meeting with (Sponsor 1) at table (2) (Delegate Request)". I want to create a new lis...
Perhaps the attached file helps you find a solution. It combines FILTER with a SEARCH for the text string in the larger text.
It doesn't appear wildcards are supported with FILTER (Maybe added at a later date?).
The workaround:
*Can also use SEARCH instead of FIND when case does not matter.
Thank you, this also looks like it would work well.