MODE.MULT function

MODE.MULT(firstParameter, otherParameters...) MODE.MULT(firstParameter; otherParameters...)

firstParameter — Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color }

The first parameter.

otherParameters — Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color } (accepts many)

Additional parameters.

Returns — { Number }, { Logical }, { Text } or { Color }

The values that appear most frequently.

Returns the values that appear most frequently. MODE.MULT(1, 2, 2, 3)MODE.MULT(1; 2; 2; 3) returns the array { 2 }{ 2 }, because 2 appears two times in the array, and 1 and 3 only appear once.

If there are multiple values that appear the same number of times, and there is no other value that appears more frequently, all such values are returned. MODE.MULT(1, 1, 2, 2, 3)MODE.MULT(1; 1; 2; 2; 3) returns the array { 1, 2 }{ 1; 2 } because 1 and 2 appear the same number of times. The returned array is sorted in ascending order (using the same technique as SORT).

MODE.MULT returns an array, which can be less convenient than a regular value. MODE.SNGL can be thought of as being equivalent to MODE.MULT, with the difference being that only the first value of the array is returned (which is the smallest value).

As a result, these formulas are equivalent:

INDEX(MODE.MULT(1, 1, 2, 2, 3), 1)INDEX(MODE.MULT(1; 1; 2; 2; 3); 1)
MODE.SNGL(1, 1, 2, 2, 3)MODE.SNGL(1; 1; 2; 2; 3)

MODE.MULT is typically used with numbers. (Indeed, spreadsheets only support this usage.) However, MODE.MULT can be used with colors, logical values and text strings too. This formula returns the array { "a" }{ "a" }:

MODE.MULT("a", "a", "b")MODE.MULT("a"; "a"; "b")

Examples

MODE.MULT(1, 2, 2, 3)MODE.MULT(1; 2; 2; 3)

Returns the array { 2 }{ 2 }, because 2 appears two times in the array, and 1 and 3 only appear once.

MODE.MULT({ 1, 2, 2, 3 })MODE.MULT({ 1; 2; 2; 3 })

Returns the array { 2 }{ 2 }, because 2 appears two times in the array, and 1 and 3 only appear once. Arrays are supported.

MODE.MULT({ 1, 2 }, 2, 3)MODE.MULT({ 1; 2 }; 2; 3)

Returns the array { 2 }{ 2 }, because 2 appears two times in the array, and 1 and 3 only appear once. Arrays mixed with regular values are supported.

MODE.MULT({ 1, 1, 2, 2, 3 })MODE.MULT({ 1; 1; 2; 2; 3 })

Returns the array { 1, 2 }{ 1; 2 }, because 1 and 2 appear the same number of times, and there is no other value that appears more frequently. The returned array is sorted in ascending order, with the smallest value appearing first.

MODE.MULT("a", "a", "b")MODE.MULT("a"; "a"; "b")

Returns the array { "a" }{ "a" }. MODE.MULT supports colors, logical values and text strings in addition to numbers.