Dynamic Filter

[ashishkhurana93]

I want to filter a list of numbers if no. >= 80. It should be dynamic. If i enter 70 instead of 80, it should give me no. >=70.

I can implement it with if else function but i don't want blanks in between.

Is there any way?

I have attached sample excel with dummy input and output

[Glenn Kennedy]

Try:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$14)/($A$2:$A$14>=$C$2),ROWS($1:1))),"")