The mode is the most frequently occurring number in a set of data.
When there is just one mode in a set of data, MODE.MULT will return a single result.
If there is more than one mode in supplied data, MODE.MULT will return more than one result.
If there are no modes, MODE.MULT will return #N/A.
The MODE.MULT function takes multipleargumentsin the formnumber1,number2,number3, etc.
Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.
MODE ignores empty cells, text values, and the logical values TRUE and FALSE.
The MODE function will accept up to 254 separate arguments.
In earlier versions of Excel, you will need to enter the formula as amulti-cell array formula.
See below for more information.
MODE returns the most frequently occurring number(s) in supplied data.
Horizontal array
The MODE.MULT function returns results in a vertical array.
For example, =MEDIAN(1,2,3,4,5) returns 3.
MODE Function
The Excel MODE function returns the most frequently occurring number in a numeric data set.
For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
MODE.SNGL Function
The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set.
For example, =MODE.SNGL(1,2,4,4,5,5,5,6) returns 5.
