Down, not Up

[gatortech]

I am using this formula, but it returns nth number values from the bottom up, rather than from the top down. Can it be made to search from top down?

=INDEX(A:A,LARGE(INDEX(ISNUMBER(A2:A50)*ROW(A2:A50),0),6))

Now, the way it is shown, it will return the numerical value from cell A45 (providing there are no intervening blank cells.

gatortech

[TMS]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.