[ Ссылка ] Use the Excel RANK function to compare numbers to other numbers in the same list. Show which student got the highest test score, and which student had the lowest score.

If ties occur in the rankings, use a formula in the adjacent column to break the ties, based on another number, such as how much time each student spent writing the test.

свернуть