Excel Drop Down List Filter. Drop down from filtered list. In data validation dialogue box select the settings tab.
Here s a new video that shows how to set up the drop down from a filtered. In this video we ll build a dropdown list using dynamic arrays to filter data. Filter with dynamic dropdown list.
First insert the drop down list.
Our sample data consists of a 2 column table. Go to data data validation. In settings tab select. Drop down from filtered list drop down from filtered list.
