Formula Guide

The Excel MODE Function
explained simply

MODE returns the value that appears most often in a range — useful when "typical" means "most common," not "average."

ExcelPro · 3 min read · Updated June 2026
Contents
  1. What does MODE do?
  2. Syntax
  3. 3 examples
  4. FAQ

What does MODE do?

MODE finds the value that occurs most frequently in a range of numbers. Unlike AVERAGE or MEDIAN, it tells you the single most repeated value, not a calculated central point.

It is most meaningful with whole numbers or categories that genuinely repeat — like the most common order size, or the most frequently booked appointment time.

Syntax

=MODE(number1, [number2], ...)
ArgumentDescription
number1 requiredA number or range to analyze.
number2, ... optionalAdditional numbers or ranges.

Examples

Example 1
Most common order size
=MODE(A2:A50)

If most orders in A2:A50 are for 3 units, this returns 3.

Example 2
Most frequent test score
=MODE(B2:B30)

Finds the score that the most students achieved, distinct from the class average.

Example 3
No repeated values
=MODE(1,2,3,4,5)

Returns #N/A — MODE requires at least one value to repeat; with no repeats, there is no mode.

Common mistakes

⚠️ Expecting MODE to handle text

Classic MODE only works with numbers. For text, you would need a different approach like COUNTIF combined with INDEX/MATCH.

⚠️ Assuming there is always a mode

If every value in the range is unique, MODE returns #N/A.

FAQ

What if there are two equally common values?
Classic MODE returns only the first one it finds. MODE.MULT (a newer array function) can return all of them.

Practise Excel with real data

ExcelPro has 700+ hands-on Excel exercises across 7 career tracks — free to start, no download needed.

Start practicing free →

Related formulas

MEDIAN AVERAGE STDEV