Loading request...
I want to filter rows in my Excel sheet where a cell contains specific text, allowing for partial matches instead of exact matches, to improve my search functionality.
I have a resource guide that is auto-populated from a microsoft form. I have a tab in the workbook for searching the guide for a specific category. issue is, one row might contain more than one category. Currently, i am able to filter for rows with cells that contain only one category (B2). B2 is the cell where the search query goes. How can I make it so I can filter for rows with \*B2, B2\*? (currently at =FILTER(Resources!F3:O100,Resources!F3:F100=Search!B2,””)