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
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | No | Up 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)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Mode | 48500 |
| 3 | Ben | South | 48500 | ||
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
=MODE.SNGL(C2:C8) Explain
Example 2 — Most common order quantity
Useful for setting a default pack size.
C2fx=MODE.SNGL(A2:A7)
| A | B | C | |
|---|---|---|---|
| 1 | Quantity | Most common | |
| 2 | 3 | 5 | |
| 3 | 5 | ||
| 4 | 5 | ||
| 5 | 8 | ||
| 6 | 5 | ||
| 7 | 2 |
=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
- Use MODE.MULT to list every value tied for most common.
- Related functions: MODE.MULT, MEDIAN, AVERAGE, COUNTIF.

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.