Getting the rank of a desired number in a list

Let's find the rank of Target Length 3 according to its length in the list.

�RANK�() formula provides to find the rank of a data in the list.

In the paranthesis, the first part shows the cell of desired number, the second part is the range which rank of the number is searced, the third part is the decision of whether the rank is considered as descending(0) or ascending(non-zero). 

Related Trainings

Highest Paid Celebrities

Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insights using rankings, basic statististics and conditional sta...


International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


Profitability of a Theater

Profitability of a Theater

Using four operations and statistical functions over a scenario which is related plays tickets status of a theater.