RANK

Syntax:

RANK ( number , number-list [ , order ] )

Description: Computes the rank of a number in a list of numbers. RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers.

Arguments:

Name	Type	Description
number	number	The number whose rank is to be found.
number-list	reference	Designates the list of numbers. Non-numeric values in this list are ignored.
order	number	Specifies how number is to be ranked. If zero or omitted, number is ranked as if the list were sorted in descending order. If order is any non-zero value, number is ranked as if the list were sorted in ascending order.

Return Type and Value: number – The rank of a number in a list of numbers.

example: