RANK.EQ

Returns the rank of a value in a data set.

Syntax:

RANK.EQ( value:number, data:Range or Array {, order:Number} )

Returns the rank of value in the given data range of cells (or array).

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

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

Revisions:

This function was added in Fireworkz 2.00.