Returns the most frequently occurring, or repetitive, value in an array or range of data.
MODE.SNGL(Number1; Number2; ...; Number30)
If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.
If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.
Number1, Number2, ..., Number30 are numerical values or ranges.