Advanced FILTER Function with Wildcards

New Contributor

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 Replies

@vee_amorin 

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

You can try this formula.

filter isnumber.JPG

 

@Quadruple_Pawn 

 

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

Really appreciate the quick response.