Smart Dependent Drop-Down Lists in Excel: Expandable and Exclude Blank Cells

Smart Dependent Drop-Down Lists in Excel: Expandable and Exclude Blank Cells

 

 

Create drop-down lists in Excel that are dynamic 

1. They expand as new data is added to the list,
2. they are dependent on another list and 
3. they exclude blank/empty cells on the bottom of each list. Basically they are only restricted to the cells that have values in them.  

In this video you'll learn how to use the OFFSET function to get fully dynamic dependent drop down lists. You'll then see another version which uses INDEX & MATCH as well as Excel Tables. We plug in the formula we create inside Name Manager and then use the new name inside our custom data validation formula box. 

 

Related Topics:

• Excel List Box to Display and Print Multiple Sheets as ONE Print Job with VBA 
• Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide) 
• Link Page Header to Cell Value with Excel VBA 
• Excel ActiveX Combo Box to Select Worksheets with VBA