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:

Argument	Description
number1/2/n	Up 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.