Forum Discussion
Filtering items on several keywords in different sheets
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 motor...
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