The MODE.SNGL function returns the most frequently occurring, or repetitive, value in an array or range of data.

**Syntax**:= MODE.SNGL(number1,[number2],…)

The MODE.SNGL function syntax has the following arguments:

**Number1**Required. The first argument for which you want to calculate the mode.-
**Number2, …**Optional. Arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.

**Example**: Let’s look at some Excel MODE.SNGL function examples and explore how to use the MODE.SNGL function as a worksheet function in Microsoft Excel:

Here I have a small list of numbers that represent ranks given by users of services. I want to look up the frequently given rank.

**Syntax**: =MODE.SNGL(A2:A17)

**Result**: 95

Remember in the MODE.SNGL function, if there are two or more most frequently occurring values in the supplied data, then it will return the lowest of the values.

**Note**:

- #N/A! error – Occurs when there are no duplicates in the values provided.
- #VALUE! error – Occurs when the value provided to the function is non-numeric. Non-numeric functions that are part of an array of values are ignored by the MODE.SNGL function.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- If an array or reference argument contains text, logical values, or empty cells, the values are ignored; however, cells with the value zero are included.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- The MODE.SNGL function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.