For example, =MODE(1,2,4,4,5,5,5,6) returns 5.

Excel formula: Conditional mode with criteria

Excel formula: Most frequently occurring text

Excel formula: List most frequently occurring numbers

Excel MODE function