Multiple Dropdown Lists | Dynamic Arrays | Filter Function

/in /by

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. https://youtu.be/ku17vgq4Q14

#DependentDropDownLists
#DropDownLists
#Rooster

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

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