The Excel MODE.SNGL function returns the most frequently occurring value in a set of numbers — the modern replacement for the legacy MODE function.
Syntax
| Argument | Description | |
|---|---|---|
number1 | Required | The first number, cell reference, or range to evaluate. |
number2, ... | Optional | Up to 254 additional numbers or ranges. MODE.SNGL returns the single value that appears most often. |
How to use it
MODE.SNGL scans the numbers and returns the one that repeats most often. It is the direct successor to the old MODE function and gives identical results.
If two or more values tie for most frequent, MODE.SNGL returns the first one it encounters in the data. To list every tied mode instead, use MODE.MULT. If no value repeats at all, the function returns #N/A.
Mode, median, mean: the mode is the most common value, the median is the middle value, and the mean (AVERAGE) is the arithmetic center. For categorical-style numeric data (ratings, sizes), the mode is often the most meaningful.
Try it: interactive demo
Pick a MODE.SNGL example to see the formula and its result.
Practice workbook
Frequently asked questions
What does MODE.SNGL do when there are two modes?
MODE.MULT, which returns an array.Is MODE.SNGL the same as the old MODE function?
MODE and returns identical results. The legacy MODE still works for backward compatibility.Why does MODE.SNGL return #N/A?
#N/A error. Wrap it in IFERROR to handle that case.Does MODE.SNGL work on text?
INDEX with MATCH and COUNTIF instead.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class