Premium Only Content

This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)
December 6, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists)
In this video you'll learn a lot about combo box drop-down lists in Excel:
1. How to create a combo box drop-down list
2. How to create a dependent combobox drop-down.
3. How to restrict the combo box drop-down to exclude blank cells and the best part;
4. How to overcome the problem we face with dependent data validation lists where the dependent list doesn't reset once the value for the first list is changed - you'll learn an alternative method to overcome the failure to auto-reset (we're going to automatically refresh the dependent list once the value for the first list changes)
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/dependent-combo-box/
LINKS to related videos:
Dependent drop-down list playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y
Index Match basics: https://youtu.be/F264FpBDX28
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
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
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
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
-
2:01:55
MG Show
19 hours agoPresident Trump Multilateral Meeting with European Leaders; Trump Outlines Putin Zelenskyy Meeting
17K19 -
LIVE
DoldrumDan
1 hour agoCHALLENGE RUNNER BOUT DONE WITH ELDEN RING NIGHTREIGN STORY MODE HUGE GAMING
31 watching -
10:59
itsSeanDaniel
1 day agoEuropean Leaders INSTANTLY REGRET Disrespecting Trump
12.1K14 -
16:43
GritsGG
15 hours agoThey Buffed This AR & It Slaps! Warzone Loadout!
12.3K1 -
2:05:30
Side Scrollers Podcast
19 hours agoEveryone Hates MrBeast + FBI Spends $140k on Pokemon + All Todays News | Side Scrollers Live
106K11 -
11:06
The Pascal Show
14 hours ago $1.32 earned'THEY'RE GETTING DEATH THREATS!' Jake Haro's Lawyer Breaks Silence On Emmanuel Haro's Disappearance!
14K -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
348 watching -
2:19:32
Badlands Media
1 day agoDEFCON ZERO Ep. 005: False Flags, Cyber Fronts & Global Power Plays
153K62 -
2:35:23
FreshandFit
9 hours agoWhy Black Men Don't Date Black Women Debate
43.5K38 -
2:03:42
Inverted World Live
12 hours agoBigfoot Corpse Coming to the NY State Fair | Ep. 94
111K27