Through these methods, you’re not restricted to a top 10 you can create a top 5, top 8, or any number you choose. In this post, I will show you exactly how to do it. However, when creating a top 10 with formulas on a non-sorted dataset, things become a little bit tricky. It is easy to create the list when working with sorted data, just cell link to the top 10 items in the list… easy! It’s also relatively simple when using Auto Filter, Tables and Pivot Tables, as it is a default filter setting within these features. A top 10 list is a common form for displaying information, especially on dashboards and summarized reports.
