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




About this tutorial:

Video duration: 00:15:55
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads