Excel > Functions

RANK Function

The RANK function returns the rank or position of a number within a range of numbers.

Duplicate numbers are given the same rank. This then affects the ranking of subsequent numbers. For example, if number 8 appears twice and has a rank of 4, then 9 would have a rank of 6 and no number would be ranked number 5.

The syntax for the RANK function is:

=RANK(number, ref, [order])

Argument

Purpose

number

The number whose rank you want to find

ref

The range of numbers that you want to find the ranking position within

order

How to rank the number. 0 for descending order and 1 for ascending.

Order is optional and if omitted, 0 is entered

The example below demonstrates the RANK function being used to position the numbers in a range of cells.

Using the RANK function

Function

Result

=RANK(A2,A2:A6)

2

=RANK(A3,A2:A6,1)

5

Follow us on

Facebook  Twitter  You Tube 

Other Statistical Functions

Excel 2010 Superhero Course