MODE.MULT

Excel Functions

Get most frequently occurring numbers

Syntax

EXCEL

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

Arguments

Parameter	Description
`number1`	A number or cell reference that refers to numeric values.
`number2`	[optional] A number or cell reference that refers to numeric values.

Return Value

Numbers representing mode(s)

Details

The Excel MODE.MULT function returns a vertical array of the most frequently occurring number(s) in a numeric data set. The mode is the most frequently occurring number in a set of data. When there is just one mode in a set of data, MODE.MULT will return a single result. If there is more than one mode in supplied data, MODE.MULT will return more than one result. If there are no modes, MODE.MULT will return #N/A. The MODE.MULT function takes multiple arguments in the form number1, number2, number3, etc. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MODE ignores empty cells, text values, and the logical values TRUE and FALSE. The MODE function will accept up to 254 separate arguments. In the example shown, the formula entered in D5:D9 is: In Excel 3

Examples

In the example shown, the formula entered in D5:D9 is:

EXCEL

=MODE.MULT(B5:B16)

Examples

MODE returns the most frequently occurring number(s) in supplied data. For example,

EXCEL

=MODE.MULT(1,2,4,4,5,5,5,6) // returns 5
=MODE.MULT(7,8,9,7,9) // returns 7

Examples

If there are no duplicate numbers, the MODE.MULT function returns the #N/A error:

EXCEL

=MODE(7,9,6,5,3,1,0) // returns #N/A

Examples

If there is more than one mode in a set of data, MODE.MULT will return more than one result:

EXCEL

=MODE.MULT(1,3,3,5,5,7,7,8) // returns {3,5,7}

Horizontal array

The MODE.MULT function returns results in a vertical array. To return a horizontal array, add the TRANSPOSE function:

EXCEL

=TRANSPOSE(MODE.MULT(range))

MODE.MULT

Syntax

Arguments

Return Value

Details

Examples

See Also