RANK function. Get the rank in the range.(Microsoft Excel)

Japanese version.

Get the rank in the range.

The RANK function has two functions that differ in their treatment of tied ranks.

RANK.EQIn case of a tie, the maximum rank is obtained.
RANK.AVGIn case of a tie, the average rank is obtained.

How it works

RANK.EQ

=RANK.EQ(Number,Ref,Order)
NameOmissionSpecify
NumberRequiredA number or cell from which to obtain rankings.
RefRequiredA cell range to be included in the rank calculation.
Order0How to rank.
0: Descending order.
1: Ascending order.

RANK.AVG

=RANK.AVG(Number,Ref,Order)
NameOmissionSpecify
NumberRequiredA number or cell from which to obtain rankings.
RefRequiredA cell range to be included in the rank calculation.
Order0How 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.

---

Links

Microsoft Excel Functions Statistical