# RANKAVG

Returns the rank/position of a number in a list of numbers.&#x20;

A number's rank refers to its size or value in comparison to the values of other numbers in a list. If you were to sort the list (ascending or descending), the rank of the number would be its position.

**If more than one value has the same rank, the average rank is returned.**

## Syntax

```javascript
RANKAVG(number, list, [order])
```

## Arguments

The RANKAVG function syntax has the following arguments:

* number: Required. The number whose rank you wish to find.
* list: Required. A list of numbers, or a reference to it.
* order: Optional. A number that specifies whether the numbers should be ranked ascending or descending in the list.

If the order is 0 (zero), Inforiver ranks the number as if the list is sorted in **descending order**. The highest value number is assigned a rank of 1, and so on.

If the order is omitted or any nonzero value is entered, Inforiver ranks the number as if the list is sorted in **ascending order**. The lowest value number is assigned a rank of 1, and so on.

## Example

```javascript
RANKAVG(2,[1,2,2,5,4],0)
// returns 3.5

RANKAVG(2,[1,2,2,5,4],1)
// returns 2.5
```

The RANKAVG function can be used to rank the values of multiple entities in important metrics such as score, cost, revenue, and sales, particularly when there is a possibility of more duplicate values.

In the example below, we have used the RANKAVG function to rank the sales across different product categories. The average rank is returned for duplicates.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FHD3belTIXA4lmS5uxZmC%2Fimage.png?alt=media&#x26;token=d012e9d9-38e7-4380-81bb-d0ff246dccf8" alt=""><figcaption><p>RANKAVG function</p></figcaption></figure>

{% hint style="info" %}
We used the **SELECT** function to select a range of columns from 1 to 5 for the 'Sales' measure.
{% endhint %}

## Excel Equivalent

[RANKAVG](https://support.microsoft.com/en-us/office/rank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a)
