Quick Navigation
MODE Function
Summary
The Excel MODE function identifies the most frequently occurring value in a dataset, making it perfect for finding the most common scores, ratings, or repeated measurements in your data analysis.
Syntax
MODE(number1,[number2],...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number/Range |
Yes | Required first argument - can be a single number, array, or cell reference containing numbers |
| number2 | Number/Range |
No | Optional additional arguments up to 255 total - numbers, arrays, or references |
Using the MODE Function
MODE excels at uncovering patterns in datasets by revealing the most common value. Use it for sales analysis to find typical transaction amounts, exam scoring to identify common grades, inventory analysis for typical order quantities, or any scenario where repetition reveals insights.
Common MODE Examples
Basic Mode Calculation
=MODE(A2:A7)Returns 4 as the most frequent value from dataset {5.6,4,4,3,2,4}
Multiple Ranges
=MODE(A2:A10,B2:B5)Finds most common value across two separate data ranges
Direct Numbers
=MODE(3,3,4,5,2,3,6)Returns 3 as it appears three times in the list
Frequently Asked Questions
Common Errors and Solutions
#N/A Error
Cause: No duplicate values in dataset
Solution: Verify data contains repeating numbers
#VALUE! Error
Cause: Arguments contain unconvertible text or errors
Solution: Ensure all arguments contain valid numbers
Notes
- MODE is deprecated but remains available for compatibility
- Consider MODE.SNGL or MODE.MULT for new workbooks
- Measures central tendency alongside AVERAGE and MEDIAN
- Zero values are included in mode calculation
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+