Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. For horizontal arrays, use TRANSPOSE(MODE.MULT(number1,number2,...)).

This will return more than one result if there are multiple modes. Because this function returns an array of values, it must be entered as an array formula.

MODE.MULT takes 1 required argument and 253 optional arguments:

Syntax: MODE.MULT(number1, [number2], ... )

The arguments for the MODE.MULT function are:
Argument Required? Description
number1 Required The first number argument for which you want to calculate the mode.
number2, ... Optional Number arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
comments powered by Disqus