•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com