RANK returns the rank of a number in a sample.

RANK (`number`, `ref`, `order`)

`number` is
the value the rank of which is to be determined.

`ref` is
the array or range of data in the sample.

`order` (optional)
is the sequence order.

- Order = 0 means descending from the last item of the array to the first (this is the default),
- Order = 1 means ascending from the first item of the range to the last.

`=RANK(A10,A1:A50)` returns
the ranking of the value in A10 in value range A1:A50. If `number` does
not exist within the range an error message is displayed.