MODE (Primitive Spread Function) returns the most frequently occurring value in a set of data.
SYNTAX:
MODE(value1,value2,...)
REMARKS:
Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.
If no value occurs more than once, the function does not return a value. If more than one value occurs the same number of times, the function returns the first value that repeats that same number of times.
EXAMPLES:
MODE(A3,B3,C3,D3)
MODE(A1:A9)
MODE(89,95,88,97,88,74)=88
MODE(1,2,2,3,4,5,5)=2