MODE.MULT function - The function returns a vertical array of the most common values 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
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel

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

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 1

Description: The function returns a vertical array of the most frequently occurring values, or repeating values in an array or data range. Support functions from Excel 2010 onwards.

Syntax: MODE.MULT ((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 vertical array containing the most common values in the following data table:

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 2

- In the cell to calculate enter the formula : = MODE.MULT (D6: D14)

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 3

- Press Enter -> the value is:

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 4

- Because the result is an array, the function must be entered as an array formula -> Highlight the data area containing the array to be returned -> press F2:

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 5

- Press the key combination Ctrl + Shift + Enter -> vertical array containing the most common values are:

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 6

Here, because the number of elements in the array is less than the number of array elements of my choice, the value # N / A is returned .

- Where the number of array elements returned matches the expected number of array elements -> the returned array does not contain an error value.

MODE.MULT function - The function returns a vertical array of the most common values in Excel Picture 7

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

Good luck!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

PERCENTILE.EXC function - The function returns the kth percentile of values in the range, with k in the range from 0 to 1 in Excel
percentile.exc function: the function returns the kth percentile of values in the range with k in the range from 0 to 1, excluding values 0 and 1. syntax: percentile.exc (array, k)
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
LINEST function - The function returns a line description array using the least square method in Excel
linest function: the function returns the line description array using the least squares method. syntax: linest (known_ys, [known_xs], [const], [stats])
MAX function - The function returns the largest value in a set of values in Excel
max function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel
percentile.inc function: the function returns the kth percentile of values in the range with k in the range from 0 to 1. syntax: percentile.inc (array, k)
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
TREND - The function returns values in a linear trend in Excel
trend: the function returns values in a linear trend. syntax: trend (known_ys, [known_xs], [new_xs], [const])