•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter/search when the keyword is short and generic
I was using a simple FILTER(range,ISNUMBER(SEARCH("keyword"),column),0) to filter a dataset.
The problem arose when I have to find using very short and generic keywords such as "car", which the formula also returned results like "care, card, carpets, carrying, carton, etc"
Is there any way to just return results with "car" and "cars"?
Thank you so much.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#large dataset processing
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#formula generator
#Excel alternatives