How to Use Excel MODE Function in Office 365? – {with Examples}
Tags: excelfunctions, excelmodefunction
Published: 2020-09-07 11:07:15

---
title: How to Use Excel MODE Function in Office 365? – {with Examples}
published: true
date: 2020-09-07 07:01:57 UTC
tags: ExcelFunctions,ExcelMODEFunction
canonical_url: https://geekexcel.com/how-to-use-excel-mode-function-in-office-365-with-examples/
---

## Excel MODE Function:

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

In this guide, you will learn how to use **Excel MODE Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! 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 Function – Explanation:**

- This function **returns the most frequently occurring value from a range of data**.
- For example, **MODE(1,1,1,2,2,3,4,5)** will return the output values as **1**.

## **Syntax:**

**=MODE(number1, [number2],..)**

### Arguments Explanation:

**Number 1 ** – It is the first input number, or cell reference.

**Number 2** – It is an optional one. It can be a number or cell reference. Number arguments should contain **up to 255** numbers to calculate Mode.

### 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, any non-numerical characters.
- The arguments can be numbers, names, arrays, or references.

## **Examples:**

Let’s see some examples below.

### Example 1:

- Refer to the below example image.
- You can see the range of cells from **A1 to F1** , where the number **1** occurs most frequently. So, the **Mode** returns the output value as 1 in the **cell H2**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/11.png)<figcaption id="caption-attachment-13437">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/).
- This function ignores empty cells, boolean values, and text.

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

## **Closure:**

In this guide, we guided you to learn the usage of **Excel MODE Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**MODE.MULT Function**](https://geekexcel.com/how-to-use-excel-mode-mult-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 COUNTA Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/)
- [How to Use Excel MIN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)