MODE.SNGL Function

Returns the most frequent number in a set.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice MODE.SNGL in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

MODE.SNGL returns the number that appears most often. If several numbers tie, it returns the one that appears first.

It replaces the older MODE function, which still works for compatibility.

Syntax

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

Arguments

ArgumentRequired?What it does
number1YesA number, cell or range.
number2, …NoUp to 255 more numbers, cells or ranges.

Examples

Example 1 — Most common sales figure

48,500 appears twice; everything else once.

E2fx=MODE.SNGL(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000Mode48500
3BenSouth48500
4CyNorth50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=MODE.SNGL(C2:C8) Explain

Example 2 — Most common order quantity

Useful for setting a default pack size.

C2fx=MODE.SNGL(A2:A7)
ABC
1QuantityMost common
235
35
45
58
65
72
=MODE.SNGL(A2:A7) Explain

Common mistakes

  • #N/A No number repeats, so there's no mode.
  • Only numbers. MODE.SNGL ignores text. For the most common text value, use =INDEX(B2:B8,MODE.SNGL(MATCH(B2:B8,B2:B8,0))).

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.