For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
Home » PostsMost frequently occurring numberTo 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)April 14, 2025 · 1 min · 5 words · Steven LewisFor example, =MODE(1,2,4,4,5,5,5,6) returns 5.