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.
If you want to search with multiple criteria using a * as a wildcard you can use the LET function with the SEARCH to define an array you can then FILTER. It's a bit messy but it works