Top Selling Products

Question:  In order to effectively monitor the performance of the stock items, I need to have a list of the best performing products in quantity sold. This helps in planning and making sure that enough stock is available at all times. I specifically need to display a list of the top three items. How can I do this?

Answer: By using the Top 10 feature in Filtering

 Why: To extract a list of the best/worst performing items

 Applies ToExcel 2010, Excel 2007, Excel 2003
1. Enter data as given in the example below


2. Select the data range E5:E16

3. For Excel 2007 & 2010, click the Data Ribbon, Filter under Sort & Filter. Refer to the screen shot below

For Excel 2003; Click on Data menu-Filter-AutoFilter as in the screen shot below

 4. Click the down arrow   in cell E5, select number Filters then top ten (Excel 2007 & 2010)

5. For Excel 2003 click the down arrow  in cell E5 and select top 10

6. The screen below will then be displayed. Make the necessary changes as given and then click Ok


As can be seen above the top 3 items have been displayed. This feature is therefore helpful in analyzing data