Measuring place performance other then the high/low

[KC2MF]

What equation would be needed to find not the first or top (or lowest or bottom) statistic, but a random placement number or figure, such as the fourth or eight highest or lowest number in a series. Does such an equation exist?

Thanks in advance for the help.

 

[anandvarma]

try small function

 

[shg]

Duplicated at http://www.mrexcel.com/forum/showthread.php?t=565837