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.