Excel Dynamic Arrays (How they will change EVERYTHING!)

October 18, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists)
‍‍‍‍
‍Excel Dynamic Array formulas are new to Excel Office 365. Don't miss out on their full potential.
★★ Link to complete Excel Dynamic Arrays Course: https://courses.xelplus.com/p/excel-dynamic-array-formulas

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://rumble.com/v2tuqys

Excel Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set): https://rumble.com/v2tv4sy

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

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

✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel #LeilaGharani