RANK (Primitive Spread Function) returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list.

SYNTAX:

RANK(Number, Ref, Order)

REMARKS:

Arguments are as follows:

Argument Description 
Number Number whose rank you want to return 
Ref Reference to the set of numbers 
Order (Optional) How to rank the number
If omitted, the function ranks the number as if the set of numbers was sorted in descending order. 
 Set Order to                                         To rank as if numbers are sorted 
 0                                                        In descending order 
 Nonzero                                               In ascending order 

The RANK function gives duplicate numbers the same rank. The presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers, if the number 12 appears twice and has a rank of 4, then 13 would have a rank of 6 (no number would have a rank of 5). 

EXAMPLES:

RANK(B3,B1:B8,1)