Advanced FILTER Function with Wildcards

[vee_amorin]

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 column we’ll call Category.

We’ve had a few issues with a few rows of data not being reflected in the other sheets because the filter is only scanning for particular texts, example =FILTER(Database, Database[Category]= “Apples”, “n/a”).

Is there a way to add wildcards to this function so that in the cases where the Category column in the Big Data Table contains “Apples/Oranges”, this row of data could be reflected in both Apples and Oranges sheets?

Thank you so much.

Vanessa

[#2]

@vee_amorin 

=FILTER(Database,ISNUMBER(SEARCH("Apples",Database[Category])),"N/A")

You can try this formula.

[#3]

@OliverScheurich 

Thank you! I'll be sure to let you know how it goes.

Really appreciate the quick response.