Filtering items on several keywords in different sheets

Occasional Visitor



I'm currently working on a file that contains over 100.000 keywords that I need to group and filter. However I can't find a good way to do this. For example I want to filter on the word motorbike, however they can be spelled like motorbike, motor bike, moto bike and motorcycle. Is there a good way to select all these words into a new sheet so I can easily see what word is more important than others?


The attached file is an example of how my real file is constructed.

2 Replies



Are you familiar with the new FILTER function? You can use multiple criteria (in this case, multiple spellings) into the function and produce on another sheet an extract of the requested data. 


Here's a YouTube video that explains the function. Or you could upload a copy of that sample sheet (an image is less helpful, frankly) and I or someone else can create the formula in that sample.


Never tried it myself but you might find it useful (the description isn't crystal clear):