•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
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#row zero
#Excel alternatives
#B2
#filter
#category
#resource guide
#search query
#rows
#workbook
#multiple categories
#microsoft form
#auto-populated
#cell
#Search!