Excel MODE function

Function              MODE

Description        Excel MODE function returns the most frequently occurring value of a number set.

Syntax  MODE(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 will return #N/A
• The MODE 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 255 numbers.