Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

 Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

 

 

Learn how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet. In this video I'll show you a solution that requires ONE single formula. This formula also excludes blank cells on the bottom of the data validation list.  In our example the selection of a division will drive the available choices for an app in an Excel data validation list. 

 

Related Topics:

• Excel VBA tutorial for beginners: Object Properties and Methods
• Excel VBA tutorial for beginners: The Visual Basic Editor (VBE) 
• Excel Column Chart | Replicating COVID-19 Overlapped Bar Chart
• How to create barcodes in Excel that WORK!