Functions
MODE.SNGL
Most frequent value
Try it
When to use it
When should I use MODE.SNGL?
Use MODE.SNGL to find the single most frequently occurring value in a dataset — such as the most common score, defect code, or survey rating. When multiple values tie, it returns the smallest; use MODE.MULT if you need all tied values.
Used in
Syntax
MODE.SNGL(value1,...)Examples
=MODE.SNGL({1,2,3,3,4}) // => 3
=MODE.SNGL({2,2,3,3,4}) // => 2
=MODE.SNGL({1,2,3},3,4,26) // => 3