ID EN
…
#Statistical

MODE.SNGL

Excel Functions

Get most frequently occurring number

Syntax

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

Arguments

Parameter Description
number1 A number or cell reference that refers to numeric values.
number2 [optional] A number or cell reference that refers to numeric values.

Return Value

A number representing the mode.

Details

The MODE.SNGL function returns the most frequently occurring number in a set of numeric data. If supplied data does not contain any duplicate numbers, the MODE.SNGL function returns a #N/A error. The MODE.SNGL function takes multiple arguments in the form number1, number2, number3, etc. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MODE.SNGL ignores empty cells, text values, and the logical values TRUE and FALSE. The MODE function will accept up to 254 separate arguments. In the example shown, the formula in D5 is: MODE.SNGL returns the most frequently occurring number in supplied data. For example, If there are no duplicate numbers, the MODE function returns the #N/A error:

Examples

Examples

In the example shown, the formula in D5 is:

EXCEL 
=MODE.SNGL(B5:B14) // returns 95
Examples

MODE.SNGL returns the most frequently occurring number in supplied data. For example,

EXCEL 
=MODE.SNGL(1,2,4,4,5,5,5,6) // returns 5
=MODE.SNGL(7,8,9,7,9) // returns 7
Examples

If there are no duplicate numbers, the MODE function returns the #N/A error:

EXCEL 
=MODE.SNGL(7,9,6,5,3,1,0) // returns #N/A

See Also

AVERAGE MEDIAN MODE MODE.SNGL