This week's new Excel Tip shows you how to use the RANK function in Excel to automatically rank a list of items. For example, we'll rank our monthly sales figures from 1 to 12.

/tips/excel/rank-function

Enjoy.

Reg Rank function Link  UP  11 years ago Sir, The rank function example as shown to us by you at "http://599cd.com/tips/excel/rank-function" skips rank 11 or supposed to skips some ranks when two numbers are equal and they got equal rank. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.