Documentation/Calc Functions/MODE.SNGL

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MODE.SNGL

Category:

Statistical Analysis

Summary:

Returns the most frequently occurring, or repetitive, value in an array or range of data.

Syntax:

MODE.SNGL(Number1; Number2; ...; Number30)

Returns:

If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.

If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.

Arguments:

Number1, Number2, ..., Number30 are numerical values or ranges.

Additional details:

Examples:

=MODE.SNGL(A1:A50)

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: