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.
Syntax
=MODE.SNGL (number1, [number2], …)
Arguments
| Arguments | Description | Remarks |
| number1 | A 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.
Availability
Since 2011 for Windows.
Since 2011 for Mac.