Author: Oscar Cronquist Article last updated on May 02, 2018

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

Formula in cell C3:


Excel Function Syntax



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.


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


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

How to use the COUNTIF function

Counts the number of cells that meet a specific condition.