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:
- Cells containing Text values, logical values, or no value are ignored.
- Mode (most frequently occurring value) is calculated row wise in above example.
Result
Note:
#NUM! – Error occurs if there are no duplicates (i.e. no mode) within the supplied values.