Skip to main content

RANKEQ

Returns the rank of a number in a list of numbers. Ties receive the same rank.

Aliases: RANK

CategoryStatistical
SyntaxRANKEQ(number, ref, [order])

Parameters

ParameterRequiredDescription
numberRequiredThe number whose rank you want to find.
refRequiredThe range or array of numbers to rank against.
orderOptional0 (default) for descending rank, non-zero for ascending rank.

Example

RANKEQ(A1:A10)

Auto-generated from the EngCanvas function registry.