Menu
EXCEL MODE.SNGL FUNCTION
Excel MODE.SNGL Function Introduction
Excel Mode is available. Within a list of integers, the Sngl function returns the statistical mode (the most commonly occurring value). If the given data contains two or more most often occurring values, the function returns the lowest of these values.
Description of Excel MODE.SNGL Function
Syntax :
=MODE.SNGL( number1, [number2], … )
Parameters :
The number parameters can be up to 255 numeric values (or arrays of numeric values) for which the statistical mode should be calculated.
Step By Step Guide of MODE.SNGL Function
Example :
Excel Mode. The Sngl function is used to compute the statistical mode of the values in cells A1-A6.
Key Points
- #NUM! – Occurs if there are no duplicates (and hence no mode) among the provided data.
- #VALUE! – Occurs if a value provided straight to the function (that is, one that is not part of an array) is non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
