Article updated on April 19, 2018

The MODE.MULT function calculates the most frequent number in a cell range. It will return multiple numbers if they are equally frequent.

The MODE.MULT function is entered as an array formula.

The MODE.MULT function demonstrated in the picture above returns both 2 and 4. Both 2 and 4 exist 3 times each in cell range B3:B10.

Excel Function Syntax

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

Arguments

number1 Required. A number or reference for which you want to calculate the MODE for.
[number2] Optional. Up to 254 additional arguments.

Comments

Text and boolean values are ignored.