For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
Most frequently occurring number
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)
For example, =MODE(1,2,4,4,5,5,5,6) returns 5.