RANK function

RANK( data , order )

RANK returns the rank of each value in the given array or range of data. Order (optional) is the sequence order, either ascending (0 - default) or descending (1).

Example

The example in this section uses this data set.

 

  A B
1 Fruit Units
2 Apples 10
3 Oranges 15
4 Pears 20
2 Apples 5
3 Oranges 12
4 Pears 17

Formula

RANK( SLICE( B:B ) , ascending )

Result

2, 4, 6, 1, 3, 5

Related links:

Statistics Functions