|
<< Click to Display Table of Contents >> MODE.SNGL (most frequently occurring value) |
Syntax:
MODE.SNGL(Number1 [, Number2, Number3 ...])
Description:
Returns the mode of a data set.
The mode is the value occurring 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. In older versions, the function is unknown.
See also: