Skip to content

RANK.EQ

Statistical

RANK.EQ helps you perform summary and inferential functions for descriptive and statistical analysis.

Overview

Start with "=" then enter RANK.EQ(number, ref, [order]). Keep argument order as shown and use cell ranges where appropriate.

Backend scalar pathComplete docs

Syntax & Arity

=RANK.EQ(number, ref, [order])

2 to 3 arguments

Arguments

ArgumentRequiredTypeDescription
numberRequiredSingleNumeric input value.
refRequiredSingleInput argument used by this function.
orderOptionalSingleOptional argument for advanced control.

Example Inputs & Outputs

Formula

=RANK.EQ(<number>, <ref>, <order>)

Example Output

Statistical summary value

Replace placeholders with your worksheet values or ranges to compute a result.

Related Functions