Dec 16 2020 07:20 AM
Hi,
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.
Dec 16 2020 07:30 AM
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.
https://www.youtube.com/watch?v=9I9DtFOVPIg
Dec 16 2020 07:44 AM