Article updated on April 19, 2018

The MODE function calculates the most frequent number in a cell range.

Number 4 exists 3 times on picture above and number 2 exists only 2 times. Number 4 is the most frequent number in B3:B10.

Excel Function Syntax



number1 Required. A cell range you want to calculate the most frequent number.
[number2] Optional. Up to 254 additional arguments.

Recommended functions

How to use the AVERAGE function

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]

How to use the MEDIAN function

The MEDIAN function calculates the median based on a group of numbers. The median is the middle number of a […]