Formulas and functions > Functions from A to Z > MODE.SNGL (most frequently occurring value)

Syntax:

MODE.SNGL(Number1 [, Number2, Number3 ...])

Description:

This returns the mode of a data set.

The mode is the value that occurs most frequently in a set of numbers.

Number1, Number2, etc. are the numbers to be evaluated.

If the given numbers contain more than one mode, their smallest mode will be returned.

If the given numbers do not contain any value occurring more than once, a #N/A error value will be returned.

Example:

MODE.SNGL(1, 2, 4, 4, 4, 2, 1) returns 4

MODE.SNGL(1, 2, 4, 4, 2, 1) returns 1 (if there are multiple modes, the smallest one is returned)

MODE.SNGL(1, 4, 2) returns #N/A because no value occurs more than once.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.