Explanation
The MODE function is fully automatic and will return the most frequently occurring number in a set of numbers. For example:
=MODE(1,2,4,4,5,5,5,6) // returns 5
In the example shown, we give MODE the range B4:K4, so the formula is solved like this:
=MODE(B4:K4)
=MODE({1,2,2,1,1,2,2,2,1,1})
=2
Related formulas
Conditional mode with criteria
The MODE function has no built-in way to apply criteria. Given a range, it will return the most frequently occurring number in that range. To apply criteria, we use the IF function inside MODE to filter values in a range. In this example, the IF function filters values by group with an expression...
Most frequently occurring text
Working from the inside out, the MATCH function matches the range against itself. That is, we give the MATCH function the same range for lookup value and lookup array (B5:F5). Because the lookup value contains more than one value (an array), MATCH returns an array of results, where each number...
List most frequently occurring numbers
The core of this formula is the MODE function, which returns the most frequently occurring number in a range or array. The rest of the formula just constructs a filtered array for MODE to use in each row. The expanding range $D$4:D4 works to exclude numbers already output in $D$4:D4. Working from...
Related functions
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.
