RANK Function:
The RANK function determines the order (or rank) of a numeric value compared to other values in the same list.
In other words, it tells you which value is the highest, the second highest, and so on.
When you need to find the relative position of a number in a list, the RANK function comes in handy.
You can use it to rank values either starting with the largest value (as if sorted in descending order) or the smallest value (as if sorted in ascending order).
The syntax of the RANK function is as follows:
RANK(number, ref, [order])
Number (required): The value whose rank you’d like to find.
Ref (required): A list of numeric values to rank against. It can be supplied as an array of numbers or a reference to the list of numbers.
Order (optional): A number that specifies how to rank values:
If 0 or omitted, the values are ranked in descending order (from largest to smallest).
If 1 or any other non-zero value, the values are ranked in ascending order (from smallest to largest).
LARGE Function:
The LARGE function extracts the nth largest value from a set of data.
It takes two arguments:
Array: An array or range of numeric values.
k: Represents the position or rank. For example:
To return the smallest value in the array, provide 1 for k.
To return the fifth smallest value, provide 5 for k.
SMALL Function:
The SMALL function is similar to LARGE, but it extracts the nth smallest value from a set of data.
Its syntax is as follows:
SMALL(array, k)
Array: An array or range of numeric values.
k: The position or rank