Summary

The Excel MODE function returns the most frequently occurring number in a dataset. If one value appears more often than the others, MODE returns that value. This makes it useful for repeated numeric categories such as ratings, size codes, test scores, or hour blocks.

MODE is a legacy function in Excel. Microsoft recommends MODE.SNGL in newer workbooks, but MODE still appears in many existing files and works for the same one-result use case. If no number repeats in the dataset, the function returns #N/A because there is no mode to report.

Syntax

=MODE(number1, [number2], ...)

The arguments can be numbers, named ranges, or cell references. For example, =MODE(A1:A10) scans the numeric values in that range and returns the one that appears most often.

Arguments

• number1 - The first number, array, or reference to analyze.
• number2, ... - Additional numbers, arrays, or references.

MODE is designed for numeric data. Text, logical values, and blank cells in references are ignored. If the referenced set contains no duplicate numbers, the function returns #N/A.

MODE vs Other Functions

MODE measures repetition, not central tendency in the same sense as AVERAGE or MEDIAN.

MODE is especially useful for discrete values. It is less informative when nearly every number is unique, because the function can only return a result when at least one value repeats.

Using the MODE Function

MODE is best for datasets where repetition matters more than arithmetic balance. If customer ratings are recorded as integers from 1 to 5, the mode shows which rating appeared most often. In that situation, the result can be more interpretable than an average such as 4.2 because the mode tells you the most common actual response.

The function is also useful for repeated codes. A product ID, shift number, store code, or hour block can all be analyzed with MODE as long as the values are numeric. The returned value tells you which code occurs most frequently, which can be useful in operational reporting.

One limitation is that MODE returns only one result. If two values are tied for the highest frequency, MODE returns the first mode it finds. When the full list of tied winners matters, MODE.MULT is the better choice.

• Use MODE for repeated ratings, numeric categories, and coded activity blocks.
• Use MEDIAN or AVERAGE when you need a center measure rather than a frequency measure.
• Use MODE.MULT if tied modes are important in the analysis.

Example 1 - Find the Most Common Number

The values are 5, 8, and 5. Since 5 appears twice and 8 appears once, MODE returns 5. The example is simple, but it captures the exact logic used on larger datasets.

=MODE(B1:B3)

Example 2 - Identify the Repeated Product ID

In a list of numeric IDs, MODE returns the ID that occurs most often. That makes it useful when the worksheet stores repeated item codes as numbers and you want to know which code dominates the list.

=MODE(101, 102, 101, 105)

Example 3 - Find the Most Common Rating

Ratings are a natural use case because the values come from a small numeric scale and repetition is expected. In this example, rating 4 appears more often than rating 5, so it becomes the mode.

=MODE(B1:B3)

Example 4 - Find the Most Common Hour Block

If hour values are stored as numbers such as 14, 15, and 14, MODE returns 14 because it occurs most often. In scheduling or traffic analysis, that gives you the most common hour without building a separate frequency table first.

=MODE(B1:B3)

Conclusion Recap

• Main job: MODE returns the most frequently occurring number.
• Important limit: It returns #N/A when no number repeats.
• Best use: Repeated numeric categories such as ratings, scores, IDs, and hour blocks.
• Related choice: Use MODE.MULT when tied modes matter.