The MODE function calculates the mode of a list of numbers. The mode is the most frequently occurring number in the list.
If all the numbers occur with equal frequency then an error message is returned. However, if a subset of the numbers occur with greater frequency than the others, then the first number in the subset is returned.
For example:
MODE(4, 5, 9, 2, 9) returns 9
MODE(4, 5, 2, 9, 2, 9) returns 2
MODE(1, 2, 3, 4, 5) returns an error message
MODE will return an error message if any of the list values or values held in a range are non-numeric.
See also: