Returns a vertical array of the most frequently occurring values in a data set.
Sintaxe
MODE.MULT(number1, [number2], ...)Argumentos
number1obrigatório
The first number, range, or cell reference for which you want to calculate the mode.
number2opcional
Additional numbers, ranges, or cell references, up to 255 arguments.
The MODE.MULT function identifies the most frequently occurring values in a range or array of data. Unlike the standard MODE function which only returns a single value, MODE.MULT returns multiple results if there is a tie for the most frequent value.
=MODE.MULT({1,2,2,3,3})→{2;3}Since both 2 and 3 appear twice, the function returns both values as a vertical array.
Select the output range
Select a vertical range of cells where you want the multiple modes to appear.
Enter the formula
Type the MODE.MULT formula and press Ctrl+Shift+Enter if you are using an older version of Excel.
MODE.MULT will return a single value in the first cell of the selected range.