To rank, there must be principles. Select all data, and then sort. The prompt "Expand Table Area" will appear. You must unfold it, or it will be a mess.

There are primary keywords, secondary keywords and other options in sorting. For example, when two people have the same Chinese scores, they can be sorted according to their math scores.

Specific operation guide

0. Right-click the column heading of each topic, and then click Insert, which will insert an empty column and enter the ranking in the cell.

1, sort by Chinese scores in descending order, and then manually enter the ranking in the ranking column, 1, 2, 3, ... (fill handle can also be used to fill in, with good results).

2. Sort the math scores in descending order, and then manually enter the ranking in the ranking column, 1, 2, 3, ... (fill handle can also be used to fill in, and the effect is very good) (after this operation, some will disrupt the order of Chinese scores, but the ranking will not be wrong).

3. Arrange English in the same way.

4. Sort by total score,

This will sort according to the total score, and finally rank according to the total score, and the ranking of individual subjects will be somewhat disrupted.

For example, a student's total score 1 ranks third in Chinese.

After sorting, the student will appear in the first row of the table, with the language ranking column showing 3 and the total score ranking showing 1.

If you want to display the ranking according to the language scores, you can also select the ranking behind the language (there are specific numbers in it at this time), and then sort by this column. The table will display the ranking according to the language scores. This may upset the order of the total score, but it won't be wrong.