How to Use MODE.MULT function in Google Sheets in 2020?

by

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