RANK Function
The RANK function returns the rank/position of a value against the other values in the given set of numbers.
Formula:
=RANK(Number to rank, List of Numbers, Rank/Order)
If the rank is 0 or if it is omitted, then the function ranks the number based on the position of the number in the list considering the list to be arranged in descending order.
If the rank is 1, then the function ranks the number based on the position of the number in the list considering the list to be arranged in ascending order.
Video Tutorial:
Let us find the rank of the given number in the list of numbers, using the RANK function, with the help of the below video
