Multiple Dropdown Lists | Dynamic Arrays | Filter Function

Dependent Dropdown Lists in Excel are pretty handy to know. But there's an interesting problem when you've gotta stack multiple dependent dropdown lists and the source data might add or remove data in the different stages.

This video shows how to make this happen using Dynamic Arrays, UNIQUE and the FILTER functions.

Also check out Leila Gharani's recent video that has a slight variation and she shows a Google Sheets solution.    • How To Create MULTIPLE Dependent Drop...  

#DependentDropDownLists
#DropDownLists
#Rooster

For a list of my Excel courses at Lynda/LinkedIn:

  / oz-du-soleil  

There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

My old blog: http://datascopic.net/blog-2-2