Skip to Content

MODE.MULT

Returns a vertical array of the most frequently occurring values in an array or range of data

Syntax

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

Parameters

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

Example

=MODE.MULT(A1:A10)
Returns: ArraySince: Excel 2010