Name in English:MODE.MULT
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.
FASHION VARIOUS ( number1 , [number2], …)
- number1 (required ): The first number to evaluate.
- number2 (optional ): The second number to evaluate and up to 255 optional values.
VARIOUS MODE (A1: A10) = Modes of the numbers in the range A1: A10