RANK function. Get the rank in the range.(Microsoft Excel)
Get the rank in the range.
The RANK function has two functions that differ in their treatment of tied ranks.
| RANK.EQ | In case of a tie, the maximum rank is obtained. |
| RANK.AVG | In case of a tie, the average rank is obtained. |
Contents
How it works
RANK.EQ
=RANK.EQ(Number,Ref,Order)
| Name | Omission | Specify |
|---|---|---|
| Number | Required | A number or cell from which to obtain rankings. |
| Ref | Required | A cell range to be included in the rank calculation. |
| Order | 0 | How to rank. 0: Descending order. 1: Ascending order. |
RANK.AVG
=RANK.AVG(Number,Ref,Order)
| Name | Omission | Specify |
|---|---|---|
| Number | Required | A number or cell from which to obtain rankings. |
| Ref | Required | A cell range to be included in the rank calculation. |
| Order | 0 | How to rank. 0: Descending order. 1: Ascending order. |
Example Results
This is the difference between the results of the RANK.EQ and RANK.AVG functions.
Spill
If you specify the argument "Number" the cell range, it will be Spill.
---