Excel Function : MODE.MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
Microsoft Excel Reference Page
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.