Link to complete Excel Dynamic Arrays Course: https://www.xelplus.com/course/new-excel-functions-course/

Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done!

In this video, I take two of my popular videos which use traditional Excel complex formulas and use Dynamic array formulas instead. I also use a timer to test the time needed for the new formulas and compare it to the other videos.

Here's what happens: We create a dynamic dependent drop-down list based on a messy data set. The first list includes unique values from cells and the second dependent data validation list filters the values to the ones that belong to the category selected from the first list. I also make sure the list is dynamic so if we add more data to the table, the drop-down list will automatically update (here we use the new dynamic array spill range reference #)

I also use the sort function to get sorted names in the drop-down list.

We use 3 Excel dynamic array functions: Unique, Sort & filter.

LINKS to related videos: Extract unique items for dynamic data validation drop down list - https://youtu.be/7fYlWeMQ6L8

Excel Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set): https://youtu.be/gu4xJWAIal8

Digital Ticking Clock from DrLex1: https://youtu.be/Lsq0FiXjGHg

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel