Formualizer Docs
ReferenceFunctionsStatistics Functions

MODE.MULT

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

Summary

Use MODE.MULT when a data set can have multiple values with the same highest frequency.

Remarks

  • Returns each tied mode as a separate row in the result array.
  • Returns #N/A when every numeric value appears only once.
  • Non-numeric values in referenced ranges are ignored.

Examples

Multiple modes from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[2],[3]]
Single repeated mode still returns an array
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
[[5]]

FAQ

Why can MODE.MULT return an array result?

It emits every value tied for highest frequency as separate rows.

Runtime metadata

Category

Statistics

Signature

MODE.MULT(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

MINIFS

MINIFS: Returns the minimum numeric value in a range that meets all criteria.

MODE.SNGL

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can MODE.MULT return an array result?Runtime metadata