» Ranking a List of Numbers
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Columns A & B list the names of the players who took part in the last game and their respective scores.
We want to rank all the scores, in both descending and ascending order.
Solution:
To rank the scores in descending order (labeling the highest score as 1), use the RANK function in the following formula:
=RANK(B2,$B$2:$B$9,0)
To rank the scores in ascending order (labeling the lowest score as 1), use the RANK function in the following formula:
=RANK(B2,$B$2:$B$9,1)
Book Store:
Recommended Books:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Analysis of Financial Statements
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Financial Peace: Revisited
- Financial Risk Manager Handbook, Second Edition
- Financial Modeling - 2nd Edition
No comments have been submitted.
