Returns the most common value in a set of numbers.


MODE(number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges/arrays containing numbers.
MODE returns the number that occurs most often. If no number occurs more than once, MODE returns an error.


where cells A1:A4 contain 1, 3, 2, 3 returns 3, the number occurring most often.
MODE(3, 7, 3, 9, 9, 3, 5, 1, 9, 5)
returns [3, 9].
( -MODE(-A1:A10)=MODE(A1:A10) )
returns TRUE if there is just one mode for the data in A1:A10, and FALSE otherwise. Notice the two minus signs.

Created with Zapof