Download the featured file here: [ Ссылка ]
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at [ Ссылка ]
In this video I demonstrate how to filter or extract data based on a drop-down list selection in Excel. This method is only available to Excel 365 users. The functions used in this video are: UNIQUE, SORT and FILTER.
In the video I demonstrate how to extract data based on one drop-down list and then based on two drop-down lists.
The video will answer the following queries:
How do I extract data based on a drop-down list selection in Excel?
How do I filter data based on a drop-down list selection in Excel?
How do you populate data based on a dropdown selection in Excel?
What formula to use to pull data from a drop-down list?
How do I create a dynamic drop-down list Excel?
How do I filter data from a drop-down list in Excel?
How do I fetch data from a drop-down list?
------------------------
![](https://i.ytimg.com/vi/2LChz9U83OM/mqdefault.jpg)