How to compare the rise and fall of two students' grades with Excel function

1. First, prepare a worksheet data of students' grades, and enter "=rank (") under the ranking cell. The Ranking function is a formula to find the ranking of a certain data in the selected area.

2. Select cell d2 and enter ",",that is, "=rank(d2,", "d2" means to find the ranking of this data in a certain area.

3. Select the total unit area and enter ",",that is, "= rank (d2, $ d $2: $ d $42" and "$ d $2: $ d $42" to represent the selected area.

4. Enter "0" and press enter, that is, "= rank (d2, $ d $2: $ d $42 42,0)" 0 stands for descending order, and "1" stands for ascending order.

5. Finally, double-click the lower right corner of the cell you just filled in to fill it in, as shown in the figure below.