SOLVED

Question about multiple FILTER function

Occasional Contributor

S_(VRE{R21ZW9N4(F4N%PIN.png

In above example, there is 2 "FILTER" function used:

D:E filter A:B with number value in salary.

Then, G:H filter D:E with more than 20000.

 

Is there a way to do above 2 FILTERs in 1 formular? Like Filter(Filter()). For the first filter, I can refer to columns. But for the second one, there is no column for me to refer.

 

Thanks a lot.

4 Replies
best response confirmed by qazzzlyt (Occasional Contributor)
Solution

@qazzzlyt 

As variant

=LET( f, FILTER( range, ISNUMBER( INDEX( range,,2) ) ),
      FILTER( f, INDEX( f,,2) > 20000  ) )

@qazzzlyt 

=FILTER(A:B,ISNUMBER(B:B)*(B:B>20000))

 

Above formula works in Excel online.

Thanks for the answer and your answer of one my previous question.

@qazzzlyt , you are welcome