MODE

Get the mode (the most frequently occurring number) for a set of numbers.

Parameter List

Syntax
MODE(value1
[value2]
)
value1

A number, cell, range, or JSON array to include in the mode. For example: 20, A3, or A1:A20.

[optional] value2

Additional numbers, cells, ranges, or JSON array to include in the mode. For example: 6, A4, or B1:B20.

More details

If no number occurs more than once, the function will return an error.

Examples

MODE(A1:A5) returns 2