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