Forum Discussion
Advanced FILTER Function with Wildcards
Hi ! My team and I have been working on a project management tracker that filters information from Sheet 1 (we’ll call Big Data Table) and imports to other Sheets based on what is contained in a ...
=FILTER(Database,ISNUMBER(SEARCH("Apples",Database[Category])),"N/A")You can try this formula.
Thank you! I'll be sure to let you know how it goes.
Really appreciate the quick response.