Wauvel

Excel like a finance pro.

← The library

Statistical function

MODE.MULT

Returns an array of the most frequent numbers when there are ties.

Rarely usedDifficulty 1300 · ProficientUsage rank #306 of 520
Practice · 2 questions →

When to use it

Every value that ties for most frequent, returned as a vertical array that spills.

The shape of it

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

Worked examples

  • Tied modes

    =MODE.MULT(1,1,2,2,3) → {1;2}

    Two values tie with two occurrences each.

  • A range

    =MODE.MULT(A2:A50) → 42;36

    Two order sizes tie for most common.

  • No mode

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

    No repeats at all.

Worth knowing

  • In older Excel select several cells and confirm with Ctrl+Shift+Enter.
  • TRANSPOSE for a horizontal result.
  • COUNT(MODE.MULT(...)) tells you how many modes there are.

Where it goes wrong

  • #N/A when nothing repeats.
  • Only numbers are considered.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

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.