Return most frequently occurring number

This tutorial shows how to get the most frequently occurring number from a list using an Excel formula, with the MODE function

Excel

Return most frequently occurring number using MODE function

EXCEL FORMULA 1. Return most frequently occurring number

EXCEL

Return most frequently occurring number

=MODE($B$5:$B$12)

GENERIC FORMULA

=MODE(range)

ARGUMENTS
range: A range from which to extract the most frequently occurring number.

EXPLANATION
This formula uses the MODE function extract the most frequently occurring number from a numeric data list. This is the purpose of the MODE function.

In this example We have selected range B5 to B12 from which to extract the most frequently occurring number. Number 75 appears three times in the range which is more than any other number. If multiple numbers are considered as frequently occurring numbers and appear the same number of times in a range the formula will return the first one of these numbers that appear in the range.