Excel functions / Statistics

MODE.MULT function

Every value that is tied for most common, as a list.

Syntax

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

Arguments

When to use it

MODE.MULT lists every value that ties for most common, spilling them down a column. Where MODE picks the first of a tie, MODE.MULT shows them all.

Examples

  1. Two sizes tie

    ABC
    1Size
    23838
    34040
    438
    542
    640

    In C2: =MODE.MULT(A2:A6) → 38; 40

    Try this example

Common mistakes

MODE.MULT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try MODE.MULT in the playground

Related functions