Fresh Excel Tips

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

1. Select cell A1 and type Value. Select B2 and type Ranking.
2. In cells A2:A10, enter values from 10 to 20.
3. Select cell A2.
4. From the Standard toolbar, click the Sort Ascending icon.
5. Select cell B2 and type 1.
6. Select cells B3:B10 and type the following formula: =B2+(A2<A3).
7. Press Ctrl+Enter.

You should now be set. This works in Excel 97, 2003 and 2007.

1. How to Create a Custom Number Format in Excel 2003 & 2007
2. How to Use a custom format to create a time format
3. How to Display Day of the Week in Excel using a Custom Format
4. Identify missing numbers in a consecutive list using Excel
5. How to Create your own Style in Excel 2007