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:
LINKS to related videos:
Dependent drop-down list playlist:
Index Match basics:
★ My Online Excel Courses ►
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend:
Get Office 365:
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!