FILTER formula when filtering for multiple criteria

Copper Contributor

I want to see an array with only rows that are marked with "A" and "B" ie whatever the criteria in the range A2 - A3, is this possible with another formula or something?

 

S4LVt275X5.png

2 Replies

@FutureTax 

That could be like

=FILTER(F2:N16,COUNTIF(A2:A3,F2:F16))
A variant: =FILTER(F2:N16,((F2:F16=A2)+(F2:F16=A3)))