Excel like a finance pro.
← The libraryPractice · 3 questions →
Statistical function
MODE.SNGL
Returns the most frequently occurring number.
OccasionalDifficulty 1050 · CapableUsage rank #150 of 520
When to use it
The most frequent value. Ties go to the one that appears first; no repeats at all gives #N/A.
The shape of it
- Syntax
=MODE.SNGL(number1, [number2], ...)
Worked examples
A clear mode
=MODE.SNGL(2,3,3,5,7) → 3
3 appears twice.
No mode
=MODE.SNGL(1,2,3) → #N/A
Nothing repeats.
Most common value
=MODE.SNGL(A2:A50) → 42
The most common order size.
Worth knowing
- MODE.MULT returns every mode when there are ties.
- For text, use INDEX/MATCH with MAX(COUNTIF(...)), since MODE works only on numbers.
- Wrap in IFERROR to show "none" when nothing repeats.
Where it goes wrong
- #N/A when every value is unique.
- Ignores text and logicals, so it cannot find the most common word.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.