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

`=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.

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.

The MODE.MULT function is one of Sourcetable's statistical functions. It is used to return an array of the most frequently occurring, or repetitive values in a range of data.

The arguments for the MODE.MULT function can be numbers, arrays, or references.

Yes, all of the arguments in the MODE.MULT function must be numbers.

Yes, the MODE.MULT function ignores text, logical values, and empty cells.

Drop CSV