Excel Function : MODE.MULT

Download now!

Excel Function : MODE.MULT

Category

Statistical

Description

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MODEMULT-function-50fd9464-b2ba-4191-b57a-39446689ae8c

Syntax and Description of the MODE.MULT Excel Function

The MODE.MULT function in Excel returns the most frequently occurring number in a data set. This function is useful for finding the most common value in a data set. The syntax of the MODE.MULT function is as follows: MODE.MULT(number1, number2, ...) where number1, number2, ... are the numbers in the data set. For example, if the data set consists of the following numbers: 1, 2, 3, 3, 4, 5, 5, 5, 6, the function would return 5 since it is the most frequently occurring number in the data set.

About MODE.MULT Excel Function

MODE.MULT returns the most frequently occurring, or repetitive, value in an array or range of data.