MODE Function - Excel
Overview
The MODE function in Excel is a useful tool for identifying the most common or frequently occurring value in a range of numbers. If there are multiple modes in this function, the smallest one will get returned as the output. This function takes up to 255 arguments.
Example:
=MODE(2, 3, 5, 2, 10, 2, 11, 2, 9, 15)
Syntax:
=MODE(number1, [number2], ...)
number1: The first number or range of numbers.
[number2], ...: Optional additional numbers or ranges.
Example
In the example above, the MODE function returns a value of 2 because that is the number that appears the most in our range C2:C11.
Example: Two Modes in Range
In this example, the MODE function returns a value of 3 despite the number 5 having the same amount of occurrences. Whenever the range in the MODE function has multiple modes, the output will always be the smaller value.
