» Ranking a List of Numbers
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Advanced modelling in finance using Excel and VBA
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- How to Read A Financial Report
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- How to Pay Zero Taxes (Annual)
[SOLVED] Ranking a List of Numbers
Travis
I would like to know how to rank the whole list at once...NOT rank them one at a time - if all the data is listed in the B column, I would like to use one formula to make all the ranking numbers appear in the C column.

