MODE.MULT

INFO

This page was originally generated from official documentation.

The MODE.MULT function returns the most commonly occurring values in a dataset.

Syntax

MODE.MULT(value1, value2)

Part	Description
value1	The first value or range to consider when calculating mode.
value2	[Repeatable] Additional values or ranges to consider when calculating mode.

Notes

• MODE.MULT returns an error if all values occur only once.
• MODE.MULT returns an array formula result.

Examples

A	B
1	Raw formula
2	=MODE.MULT({10, 15, 20, 30, 10, 15})
3

Related functions

• MODE: Returns the most commonly occurring value in a dataset.