FUNCTION CATALOGUE / STATISTICAL
MODE.SNGL Excel function
Returns the most frequently occurring value.
Correct sentence to use
Find the most common value in [range].
Modify this query in PlainFormula →Example formula
=MODE.SNGL(A2:A25)
Returns the most frequently occurring value.
Syntax
MODE.SNGL(number1, [number2], …)
Argument signature: number1, [number2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.