Formualizer Docs
ReferenceFunctionsStatistics Functions

RANK.EQ

RANK.EQ: Returns the rank position of a number within a data set, with ties sharing the same rank.

Summary

RANK.EQ defaults to descending order (largest value is rank 1), and can switch to ascending order when order is non-zero.

Remarks

  • Omitting order, or setting order to 0, ranks values in descending order.
  • Any non-zero order ranks values in ascending order.
  • Tied values receive the same rank (the first matching position in the sorted list).
  • Returns #N/A if number is not found in ref.

Examples

Descending rank with direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Ascending rank with ties in a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
3

FAQ

When does RANK.EQ return #N/A?

It returns #N/A when the target number does not appear in the reference set.

Runtime metadata

Category

Statistics

Signature

RANK.EQ(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

RANK.AVG

RANK.AVG: Returns the rank position of a number, averaging the rank positions for ties.

RSQ

RSQ: Returns the coefficient of determination (`R^2`) for paired x/y data.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does RANK.EQ return #N/A?Runtime metadata