•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
Our take
When working with datasets, using a simple FILTER function alongside SEARCH can sometimes yield broader results than intended, especially with short, generic keywords like "car." This often leads to unwanted matches such as "care" and "card." To refine your search and return only the specific terms "car" and "cars," consider utilizing a more precise filtering approach. By incorporating additional logic or utilizing exact matches, you can enhance your results, ensuring they are both relevant and accurate. Let’s explore how to achieve this effectively.
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]
Read on the original site
Open the publisher's page for the full experience