# Documentation/Calc Functions/RANK.EQ

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

RANK.EQ

## Category:

Statistical Analysis

## Summary:

Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, these are given the same rank.

## Syntax:

RANK.EQ(**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:

The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.

## Examples:

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