Extract Data Based on a Drop Down List Selection in Excel | Filter Data With Drop Down List Excel

Download the featured file here: https://www.bluepecantraining.com/ext...

------------------------------------------------------------
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 https://www.bluepecan.co.uk

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?
------------------------