•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter for rows where a cell contains specific text
Our take
Are you looking to enhance your spreadsheet's search functionality? If your resource guide is auto-populated from a Microsoft Form and you need to filter rows based on multiple categories, you can achieve this by adjusting your formula. Currently, your setup filters for rows containing only one category based on the query in cell B2. To filter for rows that include both categories specified in B2, consider using a combination of functions that allows for multiple criteria. This will make your search more comprehensive and user-friendly.
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,””)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience