Article updated on February 08, 2018

The RANK function calculates the rank of a specific number compared to a list of numbers.

Formula in cell C3:

=RANK(B3,$B$3:$B$7,1)

Excel Function Syntax

RANK(number,ref,[order])

Arguments

number Required. The number you want to calculate the rank for.
Ref Required. An array or cell reference to a list of numerical values.
Order Optional. How to rank the number, 1 - ascending or 0 - descending. If omitted - descending order.

Comments

Did you know that it is possible to rank text strings? Formula in cell C3:

=COUNTIF($B$3:$B$7,"<"&B3)

The COUNTIF function allows you to do that, read more:

Learn to use the COUNTIF function

Counts the number of cells that meet a specific condition.