Premium Only Content

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
-
52:40
Candace Show Podcast
2 hours agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
45.7K32 -
LIVE
Revenge of the Cis
3 hours agoEpisode 1449: Boo This
1,996 watching -
1:20:31
Awaken With JP
4 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
54.4K27 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
65.3K24 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
79 watching -
LIVE
John Crump Live
5 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
234 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
477 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
18.8K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $1.26 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
78K30