ExcelHeroThe MODE function
Returns the value that appears most often.
In German Excel: MODALWERT
How to write it
=MODE(number1, [number2], …)- number1
- A range of numbers.
💡 If no value appears twice, MODE returns #N/A.
Try it
Which shoe size do customers buy most often?
A
B
1
Order
Size
2
1
42
3
2
39
4
3
42
5
4
44
6
5
40
7
6
42
8
7
39
9
Most often
MODE returns the value that appears most often.