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