Documentation/Calc Functions/RANK

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

RANK

Category:

Statistical Analysis

Summary:

Returns the rank of a number in a sample.

Syntax:

RANK(Value; Data; Type)

Returns:

Arguments:

Value is the value, whose rank is to be determined.

Data is the array or range of data in the sample.

Type (optional) is the sequence order. Type = 0 means descending from the last item of the array to the first (this is the default), Type = 1 means ascending from the first item of the range to the last.

Additional details:

Examples:

=RANK(A10;A1:A50) returns the ranking of the value in A10 in value range A1:A50. If the specified value does not exist within the range, an error message is displayed.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: