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

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

## Excel MODE.SNGL Function:

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

In this article, we are going to explore how to use **Excel MODE.SNGL 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.SNGL Function – Explanation:**

- The MODE.SNGL Function **returns the most frequently occurring number from the range (array) of input values**.
- For example, **MODE.SNGL** ( **18,18,90,56,18,78,30** ) returns the output value as **18**.
- This function is similar to the [**MODE function**](https://geekexcel.com/how-to-use-excel-mode-function-in-office-365-with-examples/).

## **Syntax:**

**=MODE.SNGL(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.

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

## **Examples:**

Here are the examples for your reference.

### Example 1:

- Refer to the below screenshot.
- You can see the input range from **A2:A12** and this function prints the result in the **cell C2**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-27.png)<figcaption id="caption-attachment-13454">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-24.png)<figcaption id="caption-attachment-13455">Example 2</figcaption>

## **Bottom-Line:**

In this article, you can understand the usage of **Excel MODE.SNGL Function**  **in Office 365** with its syntax, explanation, and examples. Kindly, give your **feedback** 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.MULT Function**](https://geekexcel.com/how-to-use-excel-mode-mult-function-in-office-365-with-examples/)

### Read Ahead:

- [How to Use Excel LARGE Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)
- [How to Use Excel SINH Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-sinh-function-in-office-365-with-examples/)