Exceljet

Quick, clean, and to the point

Excel MODE Function

Excel MODE function
Summary 

The Excel MODE function returns the most frequently occurring number in a numeric data set. For example, =MODE(1,2,4,4,5,5,5,6) returns 5.

Purpose 
Get most frequently occurring number
Return value 
A number representing the mode.
Syntax 
=MODE (number1, [number2], ...)
Arguments 
  • number1 - A number or cell reference that refers to numeric values.
  • number2 - [optional] A number or cell reference that refers to numeric values.
Usage notes 

The Excel MODE function returns the most frequently occurring number in a numeric data set. Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied as separate arguments.

In the example shown, the formula in M4 is:

=MODE(B4:K4)

Note: The MODE function is now classified as a "compatibility function". Microsoft recommends that MODE.SNGL or MODE.MULT be used instead.

Notes

  • If supplied numbers does not contain any duplicates, MODE will return #N/A
  • The MODE function ignores empty cells, and cells that contain boolean values or text.
  • Arguments can be numbers, names, arrays, or references.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.