The RANK function is a simple way to determine the relative position of a number within a list. It is perfect for creating leaderboards or analyzing performance metrics.
Gör det med AIPrepare your data
Ensure your list of numbers is in one column, for example, cells A2 through A10.
Enter the RANK formula
In the cell next to your first number, type =RANK(A2, $A$2:$A$10).
Lock the range
Use dollar signs ($) to lock the reference range so it doesn't change when you copy the formula down.
Fyll formeln
Double-click the fill handle at the bottom-right corner of the cell to apply the ranking to the rest of your list.
=RANK(number, ref, [order])The RANK function will assign the same rank to duplicate numbers, which will skip the next rank in the sequence.