Returns the most frequently occurring value in a dataset.
Sintaxe
MODE(number1, [number2], …)Argumentos
number1obrigatório
The first number or range of numbers for which you want to calculate the mode.
number2opcional
Additional numbers or ranges up to 255 arguments.
The MODE function identifies the value that appears most often in a given set of numbers. If there are multiple values with the same highest frequency, it returns the first one encountered. Note that this function is available for compatibility with older versions of Excel; for newer versions, MODE.SNGL or MODE.MULT are recommended.
=MODE(1, 2, 3, 3, 4)→3The number 3 appears twice, which is more frequent than any other number.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =MODE( followed by your range of numbers and a closing parenthesis.
If no two numbers are the same, the function returns the #N/A error.