FILTER function with multiple criteria already in Include syntax

[PabloXL]

Hello - question is how do you included multiple criteria in the second syntax in the FILTER function?

I have a formula like this:

=FILTER(array1,array1[column5]={“apple”;”orange”;”bananna”})

However, instead of returning all the filtered rows out of Array1 that have apple, orange, and banana in column 5 I just get #N/A.

All the posts I’ve read talk about making the Include syntax to be (array1[column5]=“apple”)+(array1[column5]=“orange”)+(array1[column5]=“banana”) but the number of fruits (in this example) will always be changing….maybe one time it will just be blueberry, but another time it could be strawberry and grape so need to have the Include syntax flexible

 

[Fluff]

How about

=FILTER(array1,ISNUMBER(XMATCH(array1[column5],{"apple";"orange";"bananna"})))

 

[PabloXL]

wow!

looks like worked great; never would have thought of that!!! thank you!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.