# RANKAVG Returns the rank/position of a number in a list of numbers. 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: The number whose rank you wish to find. Required. * list: A list of numbers, or a reference to it. Required. * order: A number that specifies whether the numbers should be ranked ascending or descending in the list. Optional. If the order is 0 (zero), Lumel Planning ranks the number as if the list were 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, Lumel Planning ranks the number as if the list were sorted in **ascending order**. The lowest value number is assigned a rank of 1, and so on. ### Example 
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 revenue across different product categories and regions. The average rank is returned for duplicates.

RANKAVG function

{% hint style="info" %} We can also use the [**SELECT**](/planning-sheets/formula-syntax/measure-column-selection-functions/select.md) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue). 
RANKAVG([Revenue], SELECT([Revenue], 1, 4), 0)
{% endhint %} ### Excel Equivalent [RANKAVG](https://support.microsoft.com/en-us/office/rank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/planning-sheets/formula-syntax/statistical-functions/rankavg.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.