How to Use Excel MODE.MULT Function in Office 365? – (with Examples)
Tags: excelfunctions, excelmodemultfunctio
Published: 2020-09-07 11:07:32

---
title: How to Use Excel MODE.MULT Function in Office 365? – (with Examples)
published: true
date: 2020-09-07 07:11:45 UTC
tags: ExcelFunctions,ExcelMODEMULTFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-mode-mult-function-in-office-365-with-examples/
---

## Excel MODE.MULT Function:

![MODE.MULT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/MODE.MULT-Function.png)<figcaption id="caption-attachment-13476">MODE.MULT Function</figcaption>

In this article, we are going to see the usage of **Excel MODE.MULT Function in Office 365** 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](https://www.microsoft.com/en-in/microsoft-365/excel)

## **MODE.MULT Function – Description:**

- 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:**

**=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.

### Usage Notes: (Must Read)

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

### Note:

- If the input range doesn’t contain any **duplicates** ( **repetitive values** ) and then this function returns [**#N/A Error**](https://geekexcel.com/how-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text-in-excel/).
- This function ignores empty cells, boolean values, and text.
- The arguments can be numbers, names, arrays, or references.

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- Kindly, refer to the below screenshot.
- You can see the vertical range of inputs from the cell **A2 to A12** , and this ** ** function gives the output in the **range C2:C5**.
- To get the output, you need to select the cell range and you need to use the **MODE.MULT Function** on the formula bar and execute it using the following keys ( **CTRL + SHIFT + ENTER** ). Now, the function will print the most frequently occurring numbers in the selected cell range. If the cell range is empty after this function produces result, then it will fill the empty cells with the “ **#N/A** ” value.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-25.png)<figcaption id="caption-attachment-13445">Example 1</figcaption>

### Example 2:

- If the input range doesn’t contain any **duplicates** ( **repetitive values** ) and then this function returns [**#N/A Error**](https://geekexcel.com/how-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text-in-excel/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-22.png)<figcaption id="caption-attachment-13446">Example 2</figcaption>

### Horizontal Array:

- If you want to apply this function for horizontal array inputs and then you can use the [**TRANSPOSE**](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/)function.
- Refer to the below formula.

**=[TRANSPOSE](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/)(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 in Office 365** with its syntax, description, and examples. Leave your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**MODE Function**](https://geekexcel.com/how-to-use-excel-mode-function-in-office-365-with-examples/)
- [**MODE.SNGL Function**](https://geekexcel.com/how-to-use-excel-mode-sngl-function-in-office-365-with-examples/)

### See Also:

- [How to Use Excel RADIANS Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-radians-function-in-office-365-with-examples/)
- [How to Use Excel CSC Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-csc-function-in-office-365-with-examples/)