Excel MODE.MULT Function

Using the Excel MODE.MULT Function


The Excel MODE.MULT returns a vertical array of the mode, or most frequently occurring values, in an array or range of data. The function will return more than one result if multiple modes exist. The function must be entered as an array formula.

For horizontal arrays, use TRANSPOSE with MODE.MULT.


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

Syntax Breakdown

Number 1
Required. First number argument for which you want to find the mode, or most frequently occurring value. Inputs can be an array, number, or reference.

Number 2
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MODE.MULT returns a vertical array of the most frequently occurring number in a data set. If a given data set doesn't contain any duplicate numbers, the function returns the #N/A error.

The MODE.MULT function must be entered an an array formula:

1. Select a vertical range of cells

2. Enter the MODE.MULT function

3. Press Ctrl + Shift + Enter

By default, the MODE.MULT function returns a vertical array. Use the TRANSPOSE function if you are working with a horizontal array. For example, {=TRANSPOSE(MODE.MULT(A1:A10))}

If a number argument is an array or reference, and the array or reference contains text, logical values, or empty cells, they will be ignored. Cells with a zero value will be included.

The function will return an error if arguments include error values or text that cannot be translated into a number.