Excel: Rank Function

In Excel, the Rank function returns the rank of a number within a set of numbers.

The syntax for the Rank function is:

Rank( number, array, order )

number is the number to find the rank for.

array is a range or array of numbers to use for ranking purposes.

order is optional. It specifies how to rank the numbers.

If order is 0, it ranks numbers in descending order.
If order is not 0, it ranks numbers in ascending order.

If the order parameter is omitted, the Rank function assumes order is 0 (descending order).

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Rank(B4, B2:B6, 1) would return 5

=Rank(B4, B2:B6, 0) would return 1

=Rank(B3, B2:B6, 0) would return 4