Wauvel

Excel like a finance pro.

← The library

Compatibility function

MODE

Returns the most frequent value in a set of numbers; still works but MODE.SNGL is the current name.

CommonDifficulty 1050 · CapableUsage rank #162 of 520
Practice · 3 questions →

When to use it

The most frequent value. Still common; MODE.SNGL is the current name with identical results.

The shape of it

Syntax
=MODE(number1, [number2], ...)

Worked examples

  • Clear mode

    =MODE(2,3,3,5,7) → 3

    A clear mode.

  • Another set

    =MODE(5.6,4,4,3,2,4) → 4

    Another set.

  • No mode

    =MODE(1,2,3) → #N/A

    No repeats.

Worth knowing

  • MODE.SNGL is identical; MODE.MULT returns all ties.
  • Numbers only.
  • Wrap in IFERROR for "none".

Where it goes wrong

  • #N/A when nothing repeats.
  • Ignores text.

Related

FORECASTPERCENTILEQUARTILERANKSTDEVNORMDIST

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.