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