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


Blue Pecan Computer Training Ltd offers onsite or online Excel training for businesses. Training can be delivered at your business premises in the southeast 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 dropdown 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 dropdown list and then based on two dropdown lists.

The video will answer the following queries:
How do I extract data based on a dropdown list selection in Excel?
How do I filter data based on a dropdown 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 dropdown list?
How do I create a dynamic dropdown list Excel?
How do I filter data from a dropdown list in Excel?
How do I fetch data from a dropdown list?