MODE

Definition/Description of Formula:

Returns the most commonly occurring value in a dataset.

Syntax:

MODE(value1, value2, ...)

• value1 - The first value or range to consider when calculating mode.
• value2, ... - [ OPTIONAL ] - Additional values or ranges to consider when calculating mode.

See Also: 

 COUNTIF: Returns a conditional count across a range.

COUNTBLANK: Returns the number of empty cells in a given range.

To use the MODE Formula, simply begin with your edited Excellentable:  

Then begin typing the MODE formula in the area you would like to display the outcome:

	A	B
1	NUMBER
2	3
3	5
4	6
5	5
6	7.6
7	5
8	2
9
10	RESULT	5