MODE Function in Excel

MODE function in Excel returns the mode (most frequently occurring number) in a group of supplied arguments.

Syntax of MODE Function in Excel:

MODE (number1, [number2], …)
  • Where the number arguments are a set of one or more numeric values for which you want to calculate the mode.

 

Example of MODE Function in Excel:

Formula:

MODE FUNCTION IN EXCEL 1

  • Cells containing Text values, logical values, or no value are ignored.
  • Mode (most frequently occurring value) is calculated row wise in above example.
Result

MODE FUNCTION IN EXCEL 2

Note:

#NUM! – Error occurs if there are no duplicates (i.e. no mode) within the supplied values.

previous-small MODE Function in Excel                                                                                                                next_small MODE Function in Excel