Using the excel Top 10 Filter

YOUR OBJECTIVE

You created an Excel table which lists your customers’ orders. You would now like to find out which five orders had the highest dollar value. You can use Excel ‘s Top 10 Filter function, a capability within AutoFilter, to display just those orders.In this learning module, you will be shown how to use the excel Top 10 AutoFilter, in Excel 2010.

Excel Top 10 AutoFilter: HOW DOES IT WORK?

The excel Top 10 AutoFilter is accessed by way of the AutoFilter selection list. First, activate the AutoFilter function for your table by clicking the Filter button in the Sort & Filter group, on the Data tab

 

Then click the filter arrow on the “Order Value” column. In the selection list that appears, select the Number Filters option, and then click excel Top 10…

 

CAUTION

The excel  Top 10 AutoFilter can only be used for numeric columns. Only numeric columns have the Number Filters among the options in the the filter arrow’s selection list. Text and date columns do not have this option.

In the excel Top 10 AutoFilter dialog box, you have several options

 

Click the arrow to specify whether you are interested in the top or bottom values of a column, i.e., orders with the highest or lowest values.

Here you can specify how many rows of data are to be displayed, for example: “Show Top 10 Items” would filter 10 rows of data from a table of 200 rows.

If you choose “Percent” instead of “Items” in that table of 200 rows, Show Top 10 Percent would cause 20 rows of data to be displayed . (Twenty (20) is 10% of 200.)

To display the five orders with the highest order value, activate the options: “Top“, 5” and “Items“.

 

After you click OK, the table rows that meet your sort criteria will be displayed.

HINT

To identify the highest or lowest Order Values, it would be just as easy to sort the table using the Sort Largest to Smallest or Sort Smallest to Largest options in the AutoFilter options list. If you select the entire table, you can also use the Sort button on the Data tab, in the Sort & Filter group.

 

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen