Find the Most Frequently Occurring Number in a List

Add to Favorites

There are two basic functions that return the most frequently occurring number from a list or range of cells.

The MODE() and MODE.SNGL() functions.

MODE

=MODE(A1:A6)

d87d0a6fcef151be414cd6f79a97c7ad.png

Result:

7e670a75e620cc7b5b654d4ac20253ef.png

MODE.SNGL

=MODE.SNGL(A1:A6)

cbeeeb05713fb0177ffa6c0565f32414.png

Result:

7f8a7373b57e4dabe26560e076617999.png

Notes

Both functions are really easy to use and they do the same thing.

However, MODE() is kept for compatibility purposes for Excel 2007 and earlier versions. I'm not sure that it matters which one you use except that, in the future, MODE() might be dropped altogether in favor of MODE.SNGL() and so it might be better to get used to using the later.

These functions only work on numbers! You can type these numbers in, with each number separated by a comma, or select a range of numbers, like I did.

Check out another one of our tutorials to find the most frequently occurring value or word in a list [LINK] ().

Make sure to download the sample file to work with these examples in Excel.


Excel Function: MODE(), MODE.SNGL()
Downloadable Files: Excel File

Similar Content on TeachExcel
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Highlight and Sort the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allow...
MODE() - Find Most Repeated Value in a List in Excel
Tutorial: The MODE() function in Excel allows you to quickly find the most repeated or frequently oc...
Make All Numbers in a List Positive in Excel
Tutorial: Take a list of numbers and make them all positive, regardless of whether the list contains...
Find the Last Column with Data in Excel VBA
Tutorial: How to find the last column in a row that has data. This includes selecting that column or...
Count the Occurrences of the Largest or Smallest Value in a Range
Tutorial: How to count the occurrence of the largest or smallest value in a range; basically, how m...