Skip to Content

MODE.SNGL

Returns the most commonly occurring value in a data set

Syntax

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

Parameters

  • number1: Required. The first number argument
  • number2: Optional. Additional numbers, up to 255

Example

=MODE.SNGL(A1:A10)
Returns: NumberSince: Excel 2010