Current location - Training Enrollment Network - Mathematics courses - Excel function to find the total score and ranking!
Excel function to find the total score and ranking!
1. First, open an Excel table.

2. Then select all tables, and don't select the title.

3. Then click the data in the toolbar above, and then click Sort.

4. Select the total score of main keywords after sorting, and then set the order as descending.

5. Then the total score will be sorted out, and then a ranking column will be added after the total score.

6. Then write 1, 2, 3 under the ranking.

7. Then drag it down and drag it to the end, and you will see the ranking.