Uploaded December 2023 | Updated November 2026, 4 days ago
In this video in our "Data to Decisions" series, let's aim to dynamically calculate the Top and Bottom N items from a dataset.
This is a frequently used analysis step while working with numerous data types like sales figures, financial performance tracking of stocks, exam scores, and much more.
In our example, we take product sales data and use the powerful combination of Excel's RANK, FILTER, SORT and IF functions to dynamically identify the Top N and Bottom N products.
With this video, you’ll learn how to easily get a dynamic list of
1:23 Top N items
5:34 Bottom N items
Thanks for watching please drop your questions or suggestions in the comments. Follow us for more exclusive content on “Data to Decisions”.
Check our detailed blog posts on our Data to Decisions page:
indzara.com/extract-top-bottom-n-values-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials
In this video in our "Data to Decisions" series, let's aim to dynamically calculate the Top and Bottom N items from a dataset.
This is a frequently used analysis step while working with numerous data types like sales figures, financial performance tracking of stocks, exam scores, and much more.
In our example, we take product sales data and use the powerful combination of Excel's RANK, FILTER, SORT and IF functions to dynamically identify the Top N and Bottom N products.
With this video, you’ll learn how to easily get a dynamic list of
1:23 Top N items
5:34 Bottom N items
Thanks for watching please drop your questions or suggestions in the comments. Follow us for more exclusive content on “Data to Decisions”.
Check our detailed blog posts on our Data to Decisions page:
indzara.com/extract-top-bottom-n-values-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials










