Answer:
=RANK (number, ref, [order])
See Explanation
Explanation:
Literally, the rank function is used to rank values (i.e. cells) in a particular order (either ascending or descending).
Take the following instances:
A column used for total sales can use rank function to rank its cells from top sales to least.
A cell used for time can also use the rank function to rank its cells from the fastest time to slowest.
The syntax of the rank function is:
=RANK (number, ref, [order])
Which means:
[tex]number \to[/tex] The rank number
[tex]ref \to[/tex] The range of cells to rank
[tex]order \to[/tex] The order of ranking i.e. ascending or descending. This is optional.
