Returns the most frequently occurring value in a data set.
Syntax
MODE.SNGL(number1, [number2], ...)Arguments
number1required
The first number, cell reference, or range for which you want to calculate the mode.
number2optional
Additional numbers, cell references, or ranges up to 254 arguments.
The MODE.SNGL function calculates the most frequently occurring, or repetitive, value in an array or range of data. If there are multiple values that occur with the same highest frequency, it returns only the first one encountered.
=MODE.SNGL(1, 2, 2, 3, 4)→2The number 2 appears most frequently in the provided set.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =MODE.SNGL( followed by your data range or numbers, then close the parenthesis.
Press Enter
Press the Enter key to calculate the most frequent value.
If there are no duplicate values in the data, MODE.SNGL returns the #N/A error.