MODE function

MODE returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.

Syntax

MODE (number 1,number 2,...number 30)

number 1, number 2, ...number 30 are numerical values or ranges.

Example

Given the array A1:A11 as follows:

Table 1. Example of the MODE function
A
1 12
2 8
3 24
4 11
5 5
6 20
7 16
8 9
9 7
10 16
11 33

=MODE(A1:A11) returns 16 as this value occurs twice in the array.