Leading the way in Microsoft Office Development

RANK(number, ref [,order])

The RANK() function returns the rank of a number in a list of numbers.

The default function will give duplicate numbers for the same rank.

Ascending Order

The simplest example of this function is to return the rank of a series of numbers in ascending order

Descending Order

It is possible to return the rank in descending order by changing the "order" argument to the value "1".

Displaying the Average

This formula must be entered as an array formula using (Ctrl + Shift + Enter).

Removing the Duplicates

It is important to note that the last IF function must extend to one "extra" cell below the actual data.

This formula must be entered as an array formula using (Ctrl + Shift + Enter).