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 separated by commas.

Note

Arguments can be numbers, names, arrays, or references containing numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value 0 are included.

Arguments that are error values or text that cannot be converted into numbers cause errors.

If the data set contains no duplicate data points, MODE.MULT() returns the #N/A error.

Background. For more information about the mode, see the description of MODE.SNGL().

Example. Compare the example for the MODE.SNGL() function.

See Also

AVERAGEA(), AVERAGEIF(), AVERAGEIFS(), GEOMEAN(), HARMEAN(), MEDIAN(), TRIMMEAN()

Sample Files

Use the MODE.MULT worksheet in the Average.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.