Excel Functions

Excel MODE.SNGL Function

Pinterest LinkedIn Tumblr

The MODE.SNGL function returns the statistical mode (the most frequently occurring value) within a list of supplied numbers.

Purpose of Excel MODE.SNGL Function

It can be used when there are 2 or more most frequently occurring values in the supplied data, the function returns the lowest of these values.

Return value

A number representing the mode.


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


number1A number or cell reference that refers to numeric values.Mandatory
[number]A number or cell reference that refers to numeric values. Optional

Usage notes

  • If supplied numbers do not contain any duplicates, MODE.SNGL will return #N/A
  • The MODE function ignores empty cells, and cells that contain boolean values or text.
  • Arguments can be numbers, names, arrays, or references.


Since 2011 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment