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/1s8TW...
To watch the full playlist
• Dynamic Array Functions
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef