LARGE and SMALL functions. Get the number corresponding to the rank.(Microsoft Excel)

Japanese version.

Get the number corresponding to the rank.

It works in reverse of the RANK function.

LARGERank in descending order.
SMALLRank in ascending order.

How it works

ArrayRequiredCell range of values to get the rank.
KRequiredRank to get the value.

Example Results

This is the difference between the results of the RANK.EQ, LARGE, and SMALL functions.

Each of the following is a pair.

  • RANK.EQ function (descending order) and LARGE function.
  • RANK.EQ function (ascending order) and SMALL function.


If you specify the argument "K" the cell range, it will be Spill.



Microsoft Excel Functions Statistical