How to Create a Custom Ranking List in Excel
For this tutorial we will use a custom ranking list. Say for instance you have a list of grades, some of them may be the same and you would like to put those grades in a special rank. To rank the list in a particular order, follow the instructions below:
How to create a custom ranking list
- Select cell A1 and type Value. Select B2 and type Ranking.
- In cells A2:A10, enter values from 10 to 20.
- Select cell A2.
- From the Standard toolbar, click the Sort Ascending icon.
- Select cell B2 and type 1.
- Select cells B3:B10 and type the following formula: =B2+(A2<A3).
- Press Ctrl+Enter.
You should now be set. This works in Excel 97, 2003 and 2007.
