MODE

Returns the value with the highest frequency in a dataset.

The MODE function returns the value that appears most frequently in a dataset. It finds the value with the highest frequency and returns only one result.

Syntax

MODE(number1, [number2], ...)

Arguments

The MODE function syntax has the following arguments:

• number1, number2, ... - The numbers or range of values for which you want to find the most frequent value. Required.

Example

MODE(10, 20, 30, 20, 40)
// returns 20
MODE(5, 8, 5, 10, 8, 5)
// returns 5

You can use the MODE function to determine the most common value in a dataset when analyzing frequently occurring metrics such as sales, scores, or costs.

If no values are repeated, the MODE function returns a #VALUE! error.

MODE function

We can also use the SELECT function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue).

Excel Equivalent

MODE