Formualizer Docs
ReferenceFunctionsStatistics Functions

MODE.SNGL

MODE.SNGL: Returns the most frequently occurring value in a data set.

Summary

MODE.SNGL returns a single mode value and reports #N/A if no value repeats.

Remarks

  • Returns the first mode encountered after sorting when frequencies tie.
  • Returns #N/A when every numeric value appears only once.
  • Alias MODE is supported.

Examples

Single mode from scalar arguments
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Single mode from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
6

FAQ

When does MODE.SNGL return #N/A?

It returns #N/A when no value repeats in the numeric dataset.

Runtime metadata

Category

Statistics

Signature

MODE.SNGL(arg1…: Number (Range))

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

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

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

MODE.MULT

MODE.MULT: Returns all modal values as a vertical array.

NEGBINOM.DIST

NEGBINOM.DIST: Returns negative-binomial probabilities for failures observed before a target success count.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does MODE.SNGL return #N/A?Runtime metadata