MODE.MULT function
Summary
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
Syntax
MODE.MULT((number1,[number2],...)
The MODE.MULT function syntax has the following arguments:
• Number1 Required. The first number argument for which you want to calculate the mode.
• Number2, ... Optional. Number arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1 Required. The first number argument for which you want to calculate the mode.
• Number2, ... Optional. Number arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=MODE.MULT(A2:A13)