Excel Function : MODE.SNGL

Download now!

Excel Function : MODE.SNGL

Category

Statistical

Description

Returns the most common value in a data set

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MODESNGL-function-f1267c16-66c6-4386-959f-8fba5f8bb7f8

Syntax and Description of the MODE.SNGL Excel Function

What is the syntax for the MODE.SNGL Excel function? The syntax for the MODE.SNGL function is as follows: =MODE.SNGL(number1,number2,...) The MODE.SNGL function takes one or more numbers as arguments and returns the value that appears most often.

About MODE.SNGL Excel Function

MODE.SNGL is an Excel function that returns the number that appears most frequently in a given data set.