RANK.EQ function in Excel

RANK.EQ returns the position of a number in a list (0 = largest first).

Syntax

=RANK.EQ(number, ref, [order])

Argument	Required?	What it is
number	Required	The number or cell to work with.
ref	Required	The list of numbers to rank against. Lock it with $ before copying down.
order	Optional	0 (or left out) ranks the largest value as 1; 1 ranks the smallest as 1.

Type the formula yourself and get it graded instantly, no Excel needed.

RANK.EQ returns the position of a number in a list (0 = largest first).

=RANK.EQ(number, ref, [order])

Argument	Required?	What it is
number	Required	The number or cell to work with.
ref	Required	The list of numbers to rank against. Lock it with $ before copying down.
order	Optional	0 (or left out) ranks the largest value as 1; 1 ranks the smallest as 1.

Type the formula yourself and get it graded instantly, no Excel needed.