The excel ranking formula is the rank function; the specific method is: first enter the formula "=RANK (cell, numerical area of ranking)" in the specified cell; then press the "Enter key" on the keyboard ; Then place the mouse in the lower right corner of the cell, and the mouse style will change; it is best to hold down the left mouse button and pull down.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
Ranking uses the RANK function. Write the formula =RANK(F2,F$2:F$16) in G2. The ranking number one obtained here is definitely wrong. Don’t worry, continue reading
Select cells F2 and G2 with the mouse. Place it in the lower right corner of cell G2, wait until it changes into shape, hold down the left button, and pull down to the bottom row of data. The total score and ranking data are now available
in order to see the ranking more clearly. Sort the rankings. Select G2 to G16, click data, sort (Picture 1), expand the selected area (Picture 2), and rank (Picture 3)
The main thing is to do the ranking. As you can see in the picture, the student from Gangwon Province is ranked first and at the top.
Related learning recommendations: excel tutorial
The above is the detailed content of What is the excel ranking formula?. For more information, please follow other related articles on the PHP Chinese website!