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.
Yes - that's great thanks, works just as expected.
StuLux23 Thanks! But, I must admit that Patrick2788 's solution is neater. No need for the IFERROR part in mine. I'd prefer ISNUMBER.
The formula in my file would then become:
=FILTER($A$2:$A$8,ISNUMBER(SEARCH($C$1,$A$2:$A$8,1)))
You're right it is a little neater (i.e. shorter) and reads easier. I'm trying to add an additional criteria to exclude any in the list that have the text "(TBC)" in them but struggling to add this to the existing formula. I've read about using * to add more criteria but can;t get the syntax right to include both arguments.