RANK.EQ

Returns the rank of a value in a data set.

Syntax:

RANK.EQ(number, array {, order:number})

Returns the rank of number in the given array.

If order is zero or omitted, the values in array must be sorted in descending order.

If order is supplied and is non-zero, the values in array must be sorted in ascending order.

Added in 2.00.