FASHION MISCELLANEOUS function

Category:Statistics

Name in English:MODE.MULT

That makes?

Returns a vertical array of the most frequently occurring or repeating values ​​in an array or range of data. It must be used as an array formula.

Syntax

FASHION VARIOUS ( number1 , [number2], …)

  • number1 (required ): The first number to evaluate.
  • number2 (optional ): The second number to evaluate and up to 255 optional values.

Examples

VARIOUS MODE (A1: A10) = Modes of the numbers in the range A1: A10

Leave a Comment