RANK function


DESCRIPTION:

Rank a number against a range of numbers.

 

SYNTAX:

=RANK( number, ref, [order] )

 

REQUIRED ARGUMENTS:

number

The number to rank.

ref

An array that contains the numbers to rank against.

 

OPTIONAL ARGUMENTS:

[order]

Specify whether to rank in ascending or descending order.