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.


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


  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.
Was this helpful?
How can we improve it?