Example: Top 10 items in a list

Sometimes you have long list and all you want are the top 10 items in an Excel List. This is used to rank or find to winners or best results.

Do it like this.

Here a list:

list of numbers

In the Filter menu select the Top 10 menu.


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.


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.



You can download this example here.