How to use MODE.SNGL Function in Excel

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.


  1. #N/A! error – Occurs when there are no duplicates in the values provided.
  2. #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.
  3. Arguments can either be numbers or names, arrays, or references that contain numbers.
  4. 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.
  5. Arguments that are error values or text that cannot be translated into numbers cause errors.
  6. The MODE.SNGL function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.







Add a Comment

Your email address will not be published. Required fields are marked *