Example: Top 10 items in a list

Sometimes you have long list and all you want are the top 10 items.

Do it like this.

Here a list:

list of numbers

In the Filter menu select the Top 10 menu.

filteredlist

The following windows open. It allows you to select the top or the bottom, meaning the smallest or the biggest numbers in the list as well as how many you want.

You can also make the filtering in percentage.

filter

By pressing OK, the job is done.

filtered list

Et voilà.

 

To find the average of this filtered area, do like following and include the SUBTOTAL function at the end.

subtotal

 

You can download this example here.