Syntax
MODE.SNGL(value1, [value2, ...])
| Parameter | Description |
|---|---|
| value1 | Parameter of the MODE.SNGL function. |
| [value2 | (Optional.) Parameter of the MODE.SNGL function. |
| ...] | Parameter of the MODE.SNGL function. |
Examples
Most common order quantity
Formula
=MODE.SNGL(C2:C500)
Returns the order quantity that appears most frequently. If customers most often order 2 units at a time, returns 2.
Peak hour of the day
Formula
=MODE.SNGL(E2:E1000)
If column E contains the hour (0-23) of each transaction, returns the hour with the most transactions.
Most common defect count
Formula
=MODE.SNGL(B2:B100)
Returns the defect count per batch that occurs most often in quality control data.
Common Errors
#N/A
Returned when every value in the data set is unique — there is no mode if nothing repeats.
#VALUE!
Occurs if non-numeric values are passed as direct arguments.
Tips
Identical to MODE
MODE.SNGL and MODE produce the same result. MODE.SNGL exists for naming consistency with MODE.MULT.
For all modes, use MODE.MULT
If you need every value that ties for the highest frequency (not just one), use MODE.MULT entered as an array formula.
Combine with COUNTIF to verify
After getting the mode, use =COUNTIF(range, mode_result) to see exactly how many times that value appears.
Try MODE.SNGL in Viztab
Import your data and use MODE.SNGL with 370+ other formulas. No signup required.
Open Viztab