# How to Use Excel MODE.MULT Function?

Excel MODE.MULT Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to find the most frequently occurring numbers in a numeric data set, you can use the MODE.MULT function in the spreadsheet.

In this article, we are going to see the usage of Excel MODE.MULT Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of MODE.MULT Function

• It is one of the built-in functions in Microsoft Excel.
• This function returns the array of most frequently occurring numbers from the input data range.
• For example, MODE.MULT(1,1,1,2,3,3,4,4,4,5) returns the output values (1,4)

## Syntax

• Here, you will see the syntax of the MODE.MULT function.
• To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
• Once you enter the formula, click the button to get the result.

=MODE.MULT(number1, [number2], …)

Parameters Description:

• Number1 – It is the first input number or cell reference.
• Number2 – It is an optional one. It can be a number or cell reference.

1) This function returns the array of values, so you need to select a vertical range of cells.
2) Then, you have to enter the MODE.MULT Formula in the formula bar.
3) After entering the formula, You have to press (CTRL + SHIFT + ENTER) keys to get the result.

Note:
1) If the input range doesn’t contain any duplicates (repetitive values) and then this function returns #N/A Error.
2) This function ignores empty cells, boolean values, and text.
3) The arguments can be numbers, names, arrays, or references.

## Examples

Let’s see examples to understand how to use the MODE.MULT Function.

• Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
• You can see the vertical range of inputs from cell B3 to B10, and this function gives the output in the range D3:D4.
• Then, you must enter the formula in the cell below to get the result.
• After entering the formula, you need to click the  button to get the output.
• If the input range doesn’t contain any duplicates (repetitive values) and then this function returns #N/A Error.

Horizontal Array:

• If you want to apply this function for horizontal array inputs and then you can use the TRANSPOSE function.
• Refer to the below formula.

=TRANSPOSE(MODE.MULT(range))

From the above examples, you can clearly learn the syntax, and explanation of MODE.MULT Function.

## Verdict

In the above article, you can learn the usage of Excel MODE.MULT Function with its syntax, description, and examples. Leave your suggestions in the comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.

## Video Tutorial

The following video will show you how to use Excel MODE.MULT function in the spreadsheet.