How to return a value ranked X out of Y from an array

Hello,

I have a column of data that looks like this:

_|A_
1|57.1%
2|76.8%
3|33.6%
4|11.8%
5|40.4%
6|21.1%
7|48.2%
8|56.4%
~
50|27.2%

I have a formula where I need to pull the value that is a certain rank, in descending order, for a calculation. For example, I need to know what the 15th largest number in the distribution is. Is there a way to retrieve this number without an additional column showing rank values? Thanks!

Hello
Try the following formula.

=INDEX($A$1:$A$50,MATCH(LARGE($A$1:$A$50,15),$A$1:$A$50,0))

Hope this helps.

Thanks daddylonglegs. So obvious! Don't know why I put Index in there. Red face!

Regards DBY