MODE.MULT function

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

Parts of a MODE.MULT function

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	Output
2	=MODE.MULT({10, 15, 20, 30, 10, 15})	10
3		15

Related functions

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