MODE
Returns the most common value in a data set. Replaced by MODE.SNGL.
Syntax
MODE(number1, [number2], ...)
Parameters
- number1: Required. The first number argument for which you want to calculate the mode
- number2: Optional. Additional number arguments, up to 255
Example
=MODE(5, 6, 4, 4, 6, 6, 7)