MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel

The following article introduces you to the MODE.SNGL function - one of the functions in the group of statistical functions that is very popular in Excel.

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 1

Description: The function returns the most frequent value, or the most repeated value in an array or data range. Support functions from Excel 2010 onwards.

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

Inside:

- number1, [number2], .): The values ​​that you want to find the median, where number1 is the required parameter, other values ​​are optional and contain up to 254 number parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- Arguments that are text or error values ​​cannot be converted to a numeric type -> cause the function to cause an error .

- If the argument is a reference array containing text values ​​or logic -> these values ​​are ignored, but the value 0 is still counted.

- If the data set does not contain repeating data -> the function returns the # N / A error value .

For example:

Find the most common value among the values ​​in the data table below:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 2

- In the cell to calculate enter the formula : = MODE.SNGL (D6: D15)

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 3

- Press Enter -> the most common value is:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 4

- Where the most common number of values ​​overlaps -> the function returns the value that appears first:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 5

- In this example, the values ​​5, 4, 3 are the values ​​with the most and the same number of occurrences in the data table, but the value 5 appears first -> the function returns the value 5.

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 6

- In case the array does not contain a repeating value -> the function returns the # N / A error value

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values ​​in an array or data range in Excel Picture 7

Above are instructions and some specific examples when using MODE.SNGL function in Excel.

Good luck!