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.MULTreturns an error if all values occur only once. -
MODE.MULTreturns 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.
