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.
Perhaps the attached file helps you find a solution. It combines FILTER with a SEARCH for the text string in the larger text.
If I also then want to exclude any that have the text "TBC" in them how would I add that to your existing formula?
Your other question crossed my previous reply.
=FILTER(FILTER($A$2:$A$8,ISNUMBER(SEARCH($C$1,$A$2:$A$8,1))),NOT(ISNUMBER(SEARCH("TBC",FILTER($A$2:$A$8,ISNUMBER(SEARCH($C$1,$A$2:$A$8,1))),1))))The formula above would Find "Sponsor 1" (in C1) but would exclude "TBC".
StuLux23 Please see attached.
- I'm getting a #VALUE! error with this formula, some of the entries have both "Sponsor 1" and "TBC" in the text string but I only want to return those where they have "Sponsor 1" but NOT "TBC" which is what your formula appears to be trying to do but I can't get it to work with my data?