MODE function

Excel MODE Function is a useful tool for finding the most frequently occurring value in a dataset. It’s like identifying the most popular number or item in a list. This can be handy in tasks like analyzing survey results, tracking sales, or studying data trends.


MODE(number1, [number2], …)


number1:The first number or range of cells you want to find the mode for.
[number2]:(Optional) Additional numbers or ranges you want to include in the calculation. You can add more if needed.

How to use

The MODE function in Excel is pretty straightforward. You just need to provide it with your data, and it will return the most frequently occurring value.


Suppose you have a list of test scores: 85, 90, 88, 90, 92, 88, 78, and 95. You can use the MODE function like this:

The result will be 88 because it’s the score that appears most often in the list.

If your data is in a range of cells, for instance, in cells A1 to A8, you can use the MODE function like this:

Excel will still return 88 as the mode because it’s the most frequently occurring value in the specified range.

Now, let’s say you have another set of data in cells B1 to B6: apples, oranges, apples, bananas, bananas, and apples. You can find the mode of this data using:

Excel will tell you that “apples” is the mode because it’s the most frequently appearing item in the list.

It’s important to remember that the MODE function can only find a single mode, even if there are multiple values with the same highest frequency. If you have a tie, Excel will choose the first one it encounters.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.