Question about multiple FILTER function

Occasional Contributor


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)


As variant

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




Above formula works in Excel online.

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

@qazzzlyt , you are welcome