MODE.MULT

Try it

When to use it

When should I use MODE.MULT instead of MODE.SNGL?

Use MODE.MULT when your data may have multiple values that all tie for the highest frequency and you want all of them returned as an array — for example, when two products sell equally often. MODE.SNGL returns only the first such value.

Used in

operations · science

Syntax

MODE.MULT(value1,...)

Examples

=MODE.MULT({10,15,20,30,10,15}) // => 10