Forum Discussion
Solved
How To Filter Data Based On Substring In Excel?
Hi, I want to filter with criteria in column B that include substrings "pickup" and "failed" in main string I write a formula: =INDEX(FILTER(A2:B7,(B2:B7="*pickup")+(B2:B7="*failed"),""),0,{1,2}) ...
According to your requirements 842160461155 shouldn't be reported, it doesn't contain "pickup" and "failed")
=FILTER(A2:B7, ISNUMBER(SEARCH("pickup",B2:B7)) * ISNUMBER(SEARCH("failed",B2:B7)))
littlevillage. Glad I could help & Thanks for providing feedback