Find the value in a column to the nth position

[Magic_Doctor]

Good evening,

A simple question:
I have a column of numbers, for example:
2
5
5
8
8
8
20
50

I would like to know the value that corresponds to (for ex.) 5th position from, of course, the beginning of the column, ie 8.

Thank you for any response.

[Ron Coderre]

With
A11:A19 containing any values

This formula returns the item in the 5th position from the top (A15):

Please Login or Register  to view this content.

See Excel Help for other uses of the INDEX function.

Does that help?

[Magic_Doctor]

Yes, Ron!

Thank you very much