- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - MODE.MULT Function
Description
The MODE.MULT function returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. For horizontal arrays, use TRANSPOSE (MODE.MULT (number1, number2...)). This will return more than one result if there are multiple modes. Since this function returns an array of values, it must be entered as an array formula.
Syntax
MODE.MULT ((number1, [number2]...)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Number1 | The first number argument for which you want to calculate the mode. | Required |
Number2, ... |
Number arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas. |
Optional |
Notes
Arguments can either be numbers or names, arrays, or references that contain numbers.
If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
If a value that is supplied directly to the function (i.e. not part of an array of supplied values) is non-numeric, MODE.MULT returns the #VALUE! error value.
If the data set contains no duplicate data points, and hence there is no mode, MODE.MULT returns the #N/A error value.
Applicability
Excel 2010, Excel 2013, Excel 2016