Statistical

MODE.SNGL Function in Excel

Returns the most frequently occurring value in a data set.

Syntax

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

Arguments

  • number1 (required): First value or range
  • number2 (optional): Additional values or ranges

Examples

  • =MODE.SNGL(A1:A100) - Most common value - Result: Mode value

MODE.SNGL for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • #N/A if no duplicate values
  • Returns first mode if multiple

Use cases

  • Most common value
  • Survey analysis
  • Frequency analysis

Frequently asked questions

  • What if there are multiple modes? MODE.SNGL returns only the first mode (lowest value if tied). Use MODE.MULT to get all modes as an array: =MODE.MULT(A1:A100) returns all values that appear most frequently.
  • Why does MODE return #N/A? MODE returns #N/A when no value appears more than once. Every value is unique, so there's no mode. Use IFERROR to handle this: =IFERROR(MODE.SNGL(A1:A100), "No mode").

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use MODE.SNGL

  • Most common value — common Statistical scenario for MODE.SNGL.
  • Survey analysis — common Statistical scenario for MODE.SNGL.
  • Frequency analysis — common Statistical scenario for MODE.SNGL.

MODE.SNGL in the Statistical category

  • Browse all Statistical functions at /categories/statistical/ for related formulas.
  • MODE.SNGL syntax: =MODE.SNGL(number1, [number2], ...)
  • number1 (required): First value or range
  • number2 (optional): Additional values or ranges
  • Confirm MODE.SNGL arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm MODE.SNGL arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • MODE.MULT (/functions/mode-mult/): Returns a vertical array of the most frequently occurring values in a data set.
  • MEDIAN (/functions/median/): Returns the median (middle value) of the given numbers. The median is the number in the middle of a set of numbers.
  • AVERAGE (/functions/average/): Returns the average (arithmetic mean) of the arguments.

Errors to watch for

  • #N/A if no duplicate values — review causes on linked error pages in the directory.
  • Returns first mode if multiple — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter MODE.SNGL on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

MODE.SNGL worked examples to copy

  • =MODE.SNGL(A1:A100) — Most common value. Expected result: Mode value.

MODE.SNGL reference summary for crawlers and offline review

  • MODE.SNGL belongs to the Statistical category in Excel. Returns the most frequently occurring value in a data set.
  • Full syntax: =MODE.SNGL(number1, [number2], ...). Open /functions/mode-sngl/ for parameters, FAQs, and related pages.
  • Common mistakes: #N/A if no duplicate values; Returns first mode if multiple
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.