Excel Function Translator Logo
    The Excel Translator

    MODE.SNGL

    Statistical

    Returns the most frequently occurring value in a dataset. If multiple values tie for most frequent, returns the first one found. Modern replacement for the legacy MODE.

    Translations
    EnglishMODE.SNGL
    FrenchMODE.SIMPLE
    SpanishMODA.UNO
    GermanMODUS.EINF
    ItalianMODA.SNGL
    PortugueseMODO.ÚNICO
    DutchMODUS.ENKELV
    PolishWYST.NAJCZĘŚCIEJ.WART
    RussianМОДА.ОДН
    TurkishENÇOK_OLAN.TEK
    CzechMODE.SNGL
    HungarianMÓDUSZ.EGY
    SwedishTYPVÄRDE.ETT
    DanishTILSTAND.SNGL
    FinnishYKSI.MOODI
    Syntax
    MODE.SNGL(number1, [number2], ...)

    Arguments

    • number1First value or range.
    • number2Optional. Up to 254 additional numbers, references, or arrays.(optional)
    Examples
    =MODE.SNGL(1,2,2,3,3,4)
    2

    2 and 3 tie; first one found returned

    Tips & Best Practices
    • •Available since Excel 2010 — same result as the legacy MODE
    • •Returns #N/A if no value repeats
    • •Use MODE.MULT to return all tied modes as an array
    Common Mistakes
    • •Expecting MODE.SNGL to return multiple values when a dataset has more than one equally frequent value - it only returns the first one it encounters, silently ignoring other ties
    • •Using MODE.SNGL on a dataset with no repeated values at all, which returns a #N/A error since there's no value that occurs more than once
    • •Confusing MODE.SNGL with MEDIAN or AVERAGE - MODE.SNGL returns the most frequently occurring value, not a measure of central tendency based on ordering or arithmetic mean
    Related Functions
    MODE.MULTReturns an array of all values tied for most frequent, addressing MODE.SNGL's limitation of only returning a single value.
    MEDIANReturns the middle value of a sorted dataset, a completely different measure of central tendency than MODE.SNGL's most-frequent-value approach.
    COUNTIFCan verify how many times a specific value repeats, useful for confirming whether MODE.SNGL's result is genuinely unique or one of several tied values.
    Frequently Asked Questions

    Why does MODE.SNGL only show one value when several numbers repeat equally often?

    MODE.SNGL only returns the single most frequent value it finds first. Use MODE.MULT instead to get an array of every value tied for most frequent.

    Why does MODE.SNGL return #N/A?

    No value in the dataset repeats - MODE.SNGL requires at least one value to appear more than once, unlike AVERAGE or MEDIAN which work on any numeric dataset.

    Is MODE.SNGL the same as the legacy MODE function?

    Yes, they produce identical results - MODE.SNGL is simply the modern equivalent with a naming convention consistent with other newer statistical functions.

    Need to translate a formula using MODE.SNGL?

    Use our translator to convert your complete formula