Excel functions / Statistics
MODE.MULT function
Every value that is tied for most common, as a list.
Syntax
=MODE.MULT(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
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
Two sizes tie
A B C 1 Size 2 38 38 3 40 40 4 38 5 42 6 40 In C2:
=MODE.MULT(A2:A6)→ 38; 40
Common mistakes
- No repeats. With no value appearing twice the result is #N/A.
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.
- Czech: MODE.MULT
- Danish: HYPPIGST.FLERE
- Dutch: MODUS.MEERV
- Finnish: MOODI.USEA
- French: MODE.MULTIPLE
- German: MODUS.VIELF
- Hungarian: MÓDUSZ.TÖBB
- Italian: MODA.MULT
- Norwegian: MODUS.MULT
- Polish: WYST.NAJCZĘŚCIEJ.TABL
- Portuguese (Brazil): MODO.MULT
- Portuguese (Portugal): MODO.MÚLT
- Russian: МОДА.НСК
- Spanish: MODA.VARIOS
- Swedish: TYPVÄRDE.FLERA
- Turkish: ENÇOK_OLAN.ÇOK
Try MODE.MULT in the playground