Question about multiple FILTER function

[qazzzlyt]

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.

[#2 · Accepted solution]

@qazzzlyt 

As variant

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

[#3]

@qazzzlyt 

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

Above formula works in Excel online.

[#4]

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

[#5]

@qazzzlyt , you are welcome