Functions
MODE
Most frequent value
Try it
When to use it
When should I use MODE instead of MEDIAN or AVERAGE?
Use MODE to find the most frequently occurring value, such as the most common order size, support ticket category code, or class score. MEDIAN and AVERAGE describe the center of the data, not its most repeated value.
What does MODE return when no value repeats?
If every value is unique, MODE returns the #N/A error because there is no most common value. Make sure your data contains at least one repeat.
Use cases
Most frequent rating in survey responses
Most common order quantity
Used in
Syntax
MODE(value1,...)Examples
=MODE({1,2,3,3,4}) // => 3
=MODE({2,2,3,3,4}) // => 2
=MODE({1,2,3},3,4,26) // => 3