MODE.MULT function - The function returns a vertical array of the most common values ​​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!