- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Compatibility - MODE Function
The MODE function replaces the MODE.SNGL function in Excel 2010.
Description
The function returns the most frequently occurring, or repetitive, value in an array or range of data.
Syntax
MODE (number1,[number2],...)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Number1 | The first number argument for which you want to calculate the mode. | Required |
| Number2, ... | Number arguments 2 to 255 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas. |
Optional |
Notes
The MODE function measures the central tendency, which is the location of the center of a group of numbers in a statistical distribution.
Arguments can be either numbers or names, arrays, or references that contain numbers.
If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
Arguments that are error values or text that cannot be translated into numbers cause errors.
If the data set contains no duplicate data points, MODE returns the #N/A error value.
Example
