Learn how to create dependent dropdown list in Excel with automatic updates with no effort from the user to make changes. In this tutorial I don't use named ranges or INDIRECT to apply data validation, instead I have OFFSET, MATCH & COUNTA functions doing the magic.

#excel #dropdownlist #learn