The MODE function
Returns the number that appears most often in a range. If no number repeats, it returns
Syntax
MODE(number1, [number2], ...)- number1
- The first number or range.
- number2, ... (optional)
- More numbers or ranges, up to 255 in all.
Examples
D1=MODE(B2:B7)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Shoe size | 8 | |
| 2 | 1001 | 8 | ||
| 3 | 1002 | 9 | ||
| 4 | 1003 | 8 | ||
| 5 | 1004 | 10 | ||
| 6 | 1005 | 9 | ||
| 7 | 1006 | 8 |
B1=MODE(4,7,7,9,4,7)
| A | B | |
|---|---|---|
| 1 | 7 |
B1=IFERROR(MODE(5,7,9),"No repeats")
| A | B | |
|---|---|---|
| 1 | No repeats |
Questions
What is the difference between MODE and MODE.SNGL?
None. MODE.SNGL is the newer name, from Excel 2010 on, and gives the same result. MODE.MULT returns every number that ties for most common.
Can MODE find the most common text?
No, MODE only looks at numbers. For text, count each value with COUNTIF and pick the one with the highest count, for example with INDEX and MATCH.