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.

Like this tutorial? Follow us on Google +

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