Video: 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/extract-data-based-on-a-drop-down-list-selection-in-excel-filter-data-with-drop-down-list-excel/

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?