SOLVED

# Question about multiple FILTER function

Occasional Contributor

# Question about multiple FILTER function

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

# Re: Question about multiple FILTER function

As variant

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

# Re: Question about multiple FILTER function

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

Above formula works in Excel online.

# Re: Question about multiple FILTER function

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

# Re: Question about multiple FILTER function

@qazzzlyt , you are welcome