Excel Function

RANK.EQ

Returns the rank of a number in a list.

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

Arguments

number

Required

Specify a single cell reference.

ref

Required

Specify a reference range. You can drag or click start/end cells.

order

Optional

Enter a numeric value.

Practice Preview

summarize sales data. Use RANK.EQ to Returns the rank of a number in a list. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 3 for order. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=RANK.EQ(B2, C2:C8, 3)

Practice This Function

Practice in Sequential Mode Back to Function List