Author: Oscar Cronquist Article last updated on October 01, 2018

The MODE.SNGL function calculates the most frequent value in an array or cell range.

Excel Function Syntax



number1 Required. A number or cell reference for which you want to calculate the MODE.SNGL for.
[number2] Optional. Up to 254 additional arguments.


Text and boolean values and empty cells are ignored.

MODE.SNGL function returns #N/A error value if there are no duplicates.