RANKEQ

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

Sample Usage

RANKEQ(94,C5:C50)
RANKEQ(94,C5:C50,TRUE)
RANKEQ(94,C5:C50,FALSE)

Syntax

RANKEQ(value, data, [order])

value - The value whose rank will be returned.
data - The array or range containing the dataset.
order - [OPTIONAL] Specifies if the ranking follows ascending or decreasing order.

Examples

RANKEQ(94,C5:C50) returns the rank of the value 94 in the cell range C5:C50.

Notes

If order is 0 (zero) or omitted, the number is ranked as if data is sorted in descending order.
If order is any nonzero value, the number is ranked as if data is sorted in ascending order.