MODE.MULT()
Syntax. MODE.MULT(number1,number2,...)
Definition. The MODEMULT() function is new in Excel 2010 and returns a vertical array of the most frequent or repeated values in an array or a data range. Use the function TRANSPOSE(MODE.MULT(number1,number2,...)) for a horizontal array.
If there are multiple mode values, the function returns several results. Because this function returns an array of values, it must be entered as an array formula.
Arguments
number1 (required). The first numeric argument for which you want to calculate the mode.
number2 (optional). At least two and up to 254 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the mode. You can also use an array or a reference to an array instead of arguments ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
