# MODE.MULT

Formulas / MODE.MULT
Calculate the most frequently occurring numbers in a data set.
`MODE.MULT(number1, [number2, ...])`
• number1 - required, first number argument
• number2, ... - [OPTIONAL] additional number arguments, can be numbers, arrays, or references containing numbers

## Examples

• `=MODE.MULT(A2:A11)`

This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set.

• `=MODE.MULT(A2:A13)`

This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some repeats. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set.

• `=MODE.MULT(A2:A14)`

This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some different numbers. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set, while the other numbers appear less than 3 times.

• `=MODE.MULT(A2:A15)`

This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some different numbers and some repeats. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set, while the other numbers appear less than 3 times.

## Summary

The MODE.MULT function in Sourcetable is used to return an array of the most frequently occurring numbers in a numeric data set. It ignores empty cells, text values, and logical values TRUE and FALSE and will return a single result if there is only one mode in the data.

• The MODE.MULT function returns an array of the most frequently occurring numbers in a numeric data set.
• It ignores empty cells, text values, and logical values TRUE and FALSE.
• The MODE function accepts up to 254 arguments; these can be numbers, names, arrays, or references.