MODE.SNGL

StatisticalExcel 2010

The value that appears most often.

Syntax

MODE.SNGL(number1, [number2], …)

Examples

=MODE.SNGL(B2:B100)

→

Good to know

MODE.MULT spills all tied modes. Plain MODE still works for compatibility.

Related functions

MEDIAN AVERAGE

More Statistical functions

AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETA.DIST BETA.INV BINOM.DIST BINOM.DIST.RANGE BINOM.INV CHISQ.DIST CHISQ.DIST.RT

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.