Dear Experts,
I have this formula
=FILTER(FILTER('[RFI Log.xlsx]RFI'!$A:$AG,ISNUMBER(SEARCH(B1,'[RFI Log.xlsx]RFI'!$AG:$AG)),""),{1,0,1,1,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})
that would search exact value from my Cell B1.
I want to be dynamic not just the exact value but also a partial text.
How would I modify my formula I have tried doing ISNUMBER(SEARCH("*"&B1&"*"
but still it's not giving me any values.
Please is anyone is kind to help me figure out.
Thanks in advance.
Rev12
I have this formula
=FILTER(FILTER('[RFI Log.xlsx]RFI'!$A:$AG,ISNUMBER(SEARCH(B1,'[RFI Log.xlsx]RFI'!$AG:$AG)),""),{1,0,1,1,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})
that would search exact value from my Cell B1.
I want to be dynamic not just the exact value but also a partial text.
How would I modify my formula I have tried doing ISNUMBER(SEARCH("*"&B1&"*"
but still it's not giving me any values.
Please is anyone is kind to help me figure out.
Thanks in advance.
Rev12