Excel Function : MODE

Download now!

Excel Function : MODE

Category

Compatibility

Description

Returns the most common value in a data set

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MODE-function-e45192ce-9122-4980-82ed-4bdc34973120

Syntax and Description of the MODE Excel Function

The syntax for the MODE function in Microsoft Excel is: MODE( number1, [number2], ... ) The MODE function returns the most frequently occurring value in a data set. The data set can be numbers, text, or logical values.

About MODE Excel Function

MODE is a function that returns the most frequently occurring value in a data set.