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:
There were errors rendering macro:
- An unknown error occurred.