Most frequently occurring number
Generic formula
=MODE(range)
Related formulas
Most frequently occurring text
List most frequently occuring numbers
Explanation
To find the most frequently occurring number in a range, you can use the MODE function.
In the example shown, the formula in M4 is:
=MODE(B4:K4)
How this formula works
The MODE function is fully automatic and will return the most frequently occurring number in a a set of numbers. For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
In the example show, 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