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
-
1:33:39
Redacted News
2 hours agoBREAKING! Europe goes NUCLEAR against Trump over pushing for PEACE in Ukraine | Redacted
53.8K72 -
1:01:13
Candace Show Podcast
2 hours agoBlake Lively's BOMBSHELL Legal Filing | Candace Ep 149
41.6K42 -
1:41:00
Darkhorse Podcast
4 hours agoIf Only We’d Known: The 265th Evolutionary Lens with Bret Weinstein and Heather Heying
44.5K23 -
1:11:22
Vigilant News Network
5 hours agoElon Musk Shuts Down RFK Jr. Critics With One Powerful Statement | The Daily Dose
18.1K6 -
LIVE
Dad Dojo Podcast
18 hours agoEP20: The Super Bowl and Solving The Economy
60 watching -
4:49
Tactical Advisor
3 days agoBest Small Handgun Optics | CH PWS Shot Show 2025
15 -
1:01:21
In The Litter Box w/ Jewels & Catturd
22 hours agoI've Got Your Proof - Right Here! | In the Litter Box w/ Jewels & Catturd – Ep. 745 – 2/19/2025
61.3K23 -
2:14:30
FreshandFit
6 hours agoDavid Icke On COVID Lies, Censorship, Secret Societies, Infiltration of MAGA, AI Control, Alternative Media Subversion And MORE!
70K33 -
1:41:41
The Quartering
8 hours agoTrump's New IVF Order, GameStop CEO Denounces Wokeness Amid Sale, and Elon Musk's DOGE Role Revealed
92.3K51 -
LIVE
Dr Disrespect
6 hours ago🔴LIVE - DR DISRESPECT - TARKOV - ZERO TO HERO PISTOL ONLY
2,375 watching