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

Use RANK.EQ to return the descending rank of cell D3 within Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CCategory	DSales
2	P001	Apple	Food	1200
3	P002	Banana	Food	980
4	P003	Notebook	Stationery	450
5	P004	Pen	Stationery	300
6	P005	Grapes	Food	1500
7	P006	Ruler	Stationery	250
8	P007	Peach	Food	860

How to Use (Formula)

=RANK.EQ(D3, D2:D8, 0)

Result

Practice This Function

Start Function Practice Back to Function List

RANK.EQ FAQ

How do I use RANK.EQ in Excel?

Use RANK.EQ when you want to rank a value in a list. Enter Number, Reference range, Order in that order, then add optional arguments when needed.

Where can I practice RANK.EQ?

Use the "Start Function Practice" button to jump straight into RANK.EQ drills.

What arguments does RANK.EQ use?

The main arguments are Number, Reference range, Order. Start with the required ones, then add optional arguments if needed.