Returns the most commonly occurring value in a dataset.
Sample Usage
MODESNGL(A2:A50)
MODESNGL(A2:A50,B2:B50)
Syntax
MODESNGL(value1, [value2, ...])
- value1 - The first number or range to consider.
- value2, .. - [OPTIONAL] Additional numbers or ranges to calculate for the mode.
Examples
MODESNGL(A2:A50) returns the most commonly occurring value in cells A2 through A50.
Notes
- MODESNGL returns an error if the data set contains no duplicate data points.