Returns the most commonly occurring values in a dataset.
Sample Usage
MODEMULT(A2:A50)
MODEMULT(A2:A50,B2:B50)
Syntax
MODE.MULT(value1, [value2, ...])
- value1 - The first number or range to consider.
- value2, .. - [OPTIONAL] Additional numbers or ranges to calculate for the mode.
Examples
MODEMULT(A2:A50) returns the most commonly occurring values in cells A2 through A50.