Menu
EXCEL MODE.MULT FUNCTION
Excel MODE.MULT Function Introduction
The MODE.MULT function in Excel returns a vertical array of statistical modes (the most often occurring values) from a list of integers.
Description of Excel MODE.MULT Function
Syntax :
=MODE.MULT( number1, [number2], … )
Parameters :
The number parameters can be up to 254 numeric values (or arrays of numeric values) for which the mode should be calculated.
Step By Step Guide of MODE.MULT Function
Example :
The Mode is shown in cells B1-B2 of the spreadsheet on the right. Mult is a function that returns the modes of the values in cells A1-A10. The data set clearly contains two modes, values 3 and 5, and therefore the Mode. Mult returns a vertical array containing these two values. As a result, it must be inserted as an array formula into the vertical range of cells B1-B2.
Key Points
- #N/A! – Occurs when there are no duplicates (and thus no mode) within the supplied values.
- #VALUE! – Occurs when a value providing direction to the function (that is, one not part of an array) is non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
