This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)

1 year ago
18

‍‍‍‍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

Loading comments...