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