If supplied data does not contain any duplicate numbers, the MODE.SNGL function returns a #N/A error.
The MODE.SNGL function takes multipleargumentsin the formnumber1,number2,number3, etc.
Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.
MODE.SNGL ignores empty cells, text values, and the logical values TRUE and FALSE.
The MODE function will accept up to 254 separate arguments.
For example, =MEDIAN(1,2,3,4,5) returns 3.
MODE Function
The Excel MODE function returns the most frequently occurring number in a numeric data set.
For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
MODE.SNGL Function
The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set.
For example, =MODE.SNGL(1,2,4,4,5,5,5,6) returns 5.
