If supplied data does not contain any duplicate numbers, the MODE function returns a #N/A error.

The MODE function takes multipleargumentsin the formnumber1,number2,number3, etc.

Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.

Excel formula: Conditional mode with criteria

MODE ignores empty cells, text values, and the logical values TRUE and FALSE.

The MODE function will accept up to 255 separate arguments.

Examples

MODE returns the most frequently occurring number in supplied data.

Excel formula: Most frequently occurring text

Microsoft recommends thatMODE.SNGLorMODE.MULTbe used instead.

For example, =MEDIAN(1,2,3,4,5) returns 3.

MODE.SNGL Function

The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set.

Excel formula: Most frequent text with criteria

For example, =MODE.SNGL(1,2,4,4,5,5,5,6) returns 5.

Excel formula: List most frequently occurring numbers

Excel formula: Most frequently occurring number

Excel AVERAGE function

Excel MEDIAN function

Excel MODE.SNGL function

Excel MODE.MULT function