Return to Excel Formulas List

Find the Most Frequent Numbers – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to determine the most frequently occurring number in a range in Excel and Google Sheets.

most frequent number Main Function

Single Most Frequent Number

We can calculate the most frequent number in a range by using the MODE Function.

MODE

In the example above, the MODE Function selected the number that occurred the most within the specified range, which is 30.

Note: The MODE Function has been “replaced” with the MODE.SNGL Function. However, the MODE Function is still available for backwards compatibility. The Functions work exactly the same.

Multiple Frequent Numbers

What happens if you have more than one number that occurs the most number of times? The MODE Function will simply pick which result to show, ignoring the others. Instead, you can use the MODE.MULT Function to output all of the most frequently occurring numbers.

MODE.MULT

The MODE.MULT Function does what its name implies, it shows the multiple numbers with the highest number of occurrences.

In the example above, the numbers 110, 150 and 220 occurred 3 times equally within the range. In using the MODE.MULT Function we did not only get the first most frequent number, but all three numbers that were the most frequent numbers within the specified range.

Most Frequently Occurring Number in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

most frequent number Google Function