MODE.MULT Function
Returns a vertical array of statistical modes within a list of given numbers
Returns a vertical array of statistical modes within a list of given numbers
The MODE.MULT function is categorized under Statistical functions. It will return a vertical array of statistical modes within a list of given numbers. The function was introduced in MS Excel 2010 and hence is unavailable in earlier versions.
As a financial analyst, MODE.MULT is useful in financial analysis, as it helps find out the most frequently occurring numbers in a given dataset.
=MODE.MULT((number1,[number2],…)
The MODE.MULT function uses the following arguments:
We can use a single array or a reference to an array instead of arguments separated by commas. We need to enter the function as an array formula.
To understand the uses of the MODE.MULT function, let’s consider a few examples:
Suppose we are given the following data:
The formula to use is:
We get the result below:
Remember, the MODE.MULT function returns an array of results and must be entered as an array formula. To enter the formula:
Suppose we are given the following data:
The MODE.MULT function returns results in a vertical array. To return a horizontal array, add the TRANSPOSE function. The formula to use is:
We get the result below:
The beauty of the MODE.MULT function is that it returns multiple modes if present in the dataset provided. MODE.MULT is different from MODE.SNGL, as the former returns an array of all of the modes, while the latter returns the lowest mode.
Suppose we are given the following data:
We can find the multiple modes in the data set. Here, the MODE.MULT function will return a vertical array containing the two values. It must be entered as an array formula into the vertical range of cells (D5-D6).
The formula to be used in cells D5 and D6 is:
Remember to select both cells while inputting the formula. Else, we will not get accurate results.
We get the result below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!