LARGE and SMALL functions. Get the number corresponding to the rank.(Microsoft Excel)
Get the number corresponding to the rank.
It works in reverse of the RANK function.
| LARGE | Rank in descending order. |
| SMALL | Rank in ascending order. |
Contents
How it works
=LARGE(Array,K)
=SMALL(Array,K)
| Name | Omission | Specify |
|---|---|---|
| Array | Required | Cell range of values to get the rank. |
| K | Required | Rank 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.
Spill
If you specify the argument "K" the cell range, it will be Spill.
---