# How to Use Excel MODE.SNGL Function?

Excel is a spreadsheet program that is developed for WindowsMacAndroid, and iOS. It helps to perform calculations on your PC. The purpose of this software is to do complicated calculations which are difficult to do manually. With the help of this spreadsheet program, you can insertorganizemaintainmanage, and calculate data.

In this article, we are going to explore how to use Excel MODE.SNGL Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

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

## Explanation of MODE.SNGL Function

• It is one of the built-in functions in Microsoft Excel.
• 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.

## Syntax

• Here, you will see the syntax of the MODE.SNGL 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.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:
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, any non-numerical values.
3) The arguments can be numbers, names, arrays, or references.

## Examples

Let’s see examples to understand how to use the MODE.SNGL 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 B9, and this function gives the output in cell D3.
• 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.