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.
IMHO, one filter is enough for this formula
=FILTER($A$2:$A$8,ISNUMBER(SEARCH($C$1,$B$2:$B$8))*NOT(ISNUMBER(SEARCH("TBC",$B$2:$B$8))))
SergeiBaklan This works great for me, however if the exclusion is blank I get a #CALC! error. Can this be modified to allow for this?
#CALC! error if the FILTER returns empty array. You may wrap FILTER by IFERROR if so, like
=IFERROR( FILTER( ... ), "" )
returning empty string or whatever you wish.