Excel MODE.SNGL Function

Using the Excel MODE.SNGL Function


The Excel MODE.SNGL returns the most frequently occurring, or repetitive, values in an array or range of data.

Since Microsoft has classified the MODE function as a compatibility function, it is recommended to use either MODE.SNGL or MODE.MULT.


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

Syntax Breakdown

Number 1
Required. First number argument for which you want to find the mode, or most frequently occurring value. Inputs can be an array, number, or reference.

Number 2
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MODE.SNGL returns the mode, or the most frequently occurring number in a data set. If a given data set doesn't contain any duplicate numbers, the function returns the #N/A error.

MODE.SNGL is used to measure the central tendency of a group of numbers. Other functions used to measure central tendency include AVERAGE and MEDIAN.

The function will return an error if arguments include error values or text that cannot be translated into a number.

If an argument is an array or reference, and the array or reference contains text, logical values, or empty cells, they will be ignored. Cells with a zero value will be included.