Formualizer Docs
ReferenceFunctionsStatistics Functions

LARGE

Returns the k-th largest value in a data set.

Summary

LARGE is useful for top-N analysis, such as highest score, second-highest sale, or third-best result.

Remarks

  • k must be at least 1.
  • Returns #NUM! if k is greater than the count of numeric values.
  • Non-numeric values in referenced ranges are ignored.

Examples

Second-largest from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
7
Third-largest from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
5

FAQ

When does LARGE return #NUM!?

It returns #NUM! when k < 1, k exceeds numeric count, or no numeric values exist.

Runtime metadata

Category

Statistics

Signature

LARGE(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

PUREREDUCTIONNUMERIC_ONLY

Source

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

KURT

Returns the sample excess kurtosis of a numeric distribution.

LINEST

LINEST: Returns linear-regression coefficients and optional fit statistics.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does LARGE return #NUM!?Runtime metadata