Excel MODE.SNGL function

Function              MODE.SNGL

Description        Excel MODE.SNGL function returns the most frequently occurring numbers in a numeric data set.

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

number1  A number or cell reference that refers to numeric values.

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

Example:

=MODE(23,21,21,56,78,99)=21

Usage Notes:

• If input numbers does not duplicates, MODE.SNGL will return #N/A
• The MODE.SNGL function ignores empty cells, and cells that contain Boolean values or text.
• Numbers can be used in function as numbers, ranges, named ranges, or cell references that contain numeric values and up to 254 numbers.