This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function · Statistics
MODE
Returns the number that appears most often.
What it does
MODE returns the most frequent value in a set of numbers. A shop can use it to see which size sells most. Newer Excel versions also offer MODE.SNGL, which works the same.
Syntax
=MODE(number1; [number2]; …)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;
Arguments
- number
- The first number, cell or range. Add more arguments for other ranges.
Example
Which shoe size was sold most often?
| A | B | C | |
|---|---|---|---|
| 1 | Shoe size | Most common | |
| 2 | 38 | 41 | |
| 3 | 41 | ||
| 4 | 39 | ||
| 5 | 41 | ||
| 6 | 40 | ||
| 7 | 41 |
The formula in C2:
=MODE(A2:A7)Result: 41
41 appears three times, more than any other size, so the result is 41.
Common mistakes
- Using it on text. It only counts numbers; for the most common word, count with
COUNTIF. - Not expecting
#N/Awhen every value appears only once. - Expecting all the winners when two values tie. It returns only the first one found.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | MODE | , |
| Deutsch | Not confirmed yet | ; |
| Français | MODE | ; |
| Español (España) | MODA | ; |
| Español (México) | MODA | , |
| 日本語 | MODE | , |
| 한국어 | MODE | , |
| 繁體中文 | MODE | , |
| ไทย | MODE | , |
| ខ្មែរ | MODE | , |
| Tiếng Việt | MODE | ; |