MODE
Returns the most common value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns the mode (Legacy).
Syntax
MODE(number1, [number2], ...)
Arguments
number1(number) — Value.
Examples
Legacy Mode
Find mode.
FORMULA
=MODE(A2:A6)
RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 2 |
| 5 | 3 |
| 6 | 4 |