Skip to main content

MODE.SNGL function

The MODE.SNGL function is one of the statistical functions. It is used to return the most frequently occurring, or repetitive, value in an array or range of data.

Syntax​

MODE.SNGL(number1, [number2], ...)

The MODE.SNGL function has the following arguments:

ArgumentDescription
number1/2/nUp to 255 numeric values for which you want to find the most frequently occurring value.

Notes​

If there is no repetitive value in the argument list, the function will return the #VALUE! error.

How to apply the MODE.SNGL function.

Examples​

The figure below displays the result returned by the MODE.SNGL function.

MODE.SNGL Function