Formualizer Docs
ReferenceFunctionsStatistics Functions

RANK.AVG

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

Summary

Use RANK.AVG when tied values should share the average of their occupied rank positions.

Remarks

  • Omitting order, or setting order to 0, ranks values in descending order.
  • Any non-zero order ranks values in ascending order.
  • If number appears multiple times, the function returns the mean of those rank positions.
  • Returns #N/A if number is not found in ref.

Examples

Average rank for tied values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.5
Ascending average rank from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
3.5

FAQ

How are ties handled by RANK.AVG?

All tied occurrences share the average of their rank positions.

Runtime metadata

Category

Statistics

Signature

RANK.AVG(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

QUARTILE.INC

QUARTILE.INC: Returns an inclusive quartile value for a data set.

RANK.EQ

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

On this page

SummaryRemarksExamplesRelated functionsFAQHow are ties handled by RANK.AVG?Runtime metadata