Excel Dynamic array Video#8:Get top N values, dynamic range & draw dynamic chart - Filter Function

NDAF08
Hello and welcome to a new video discussing dynamic array functions, video number 8
No need to remind you that dynamic array functions are working only with office 365, if you are using any other version of the excel, you won’t be able to practice the exercise in this video
In this video we will continue with filter function, we are going to see how to extract the to N valve from a table using filter function , then create a dynamic range based on the output of the spilled array, draw a dynamic chart using this dynamic range and also create a dynamic title for the chart
While working on the example we are going to discuss some other functions beside filter function such as:
Larger , Index, and Sort
Use large, filter and sort to extract top N values: 1:32
Named ranges based on a spilled array (using: #): 9:12
Draw a chart based a dynamic range 10:00
Dynamic chart title: 11:42

To download the excel file:
https://drive.google.com/file/d/1s8TWhoLGRm2CbvjXdMuVEZxnClb6DZWg/view?usp=sharing

To watch the full playlist
https://www.youtube.com/playlist?list=PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef