A SPECIAL RANKING LIST USING MICROSOFT EXCEL

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->.

A SPECIAL RANKING LIST USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Basic Tutorials of Excel, Create a special ranking list using Excel, Video Tutorials of Microsoft Excel 2007, Advanced Tutorials in Excel Application