A Special Ranking List - Formulas In Excel - Microsoft Excel Tutorials

16.  A special ranking list

You can use Excel to generate a special ranking list. Let’s say a worksheet contains a few values, some of which are repeated. To rank the list in a particular order, follow these instructions.

To rank a list in a particular order:

1. Select cell A1 and type Value.
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->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=DQcDmarSn7A

  Hope You Like this Tutorial - Give Comments