![]() ![]() Now we will use this unique list to create the drop-down list. This will give you a unique list as shown below. In the Remove Duplicates dialogue box, select the column where you have the list of countries.Select all the Countries and paste it at some other part of the worksheet.In the above example, the first step is to get the unique list of all the countries. While there could be repetitions of an item in your dataset, we need unique item names so that we can create a drop down filter using it. Let’s deep dive and see what needs to be done in each of these steps. Use helper columns to extract the records for the selected item.Add a drop-down filter to display these unique items.Here are the steps to create a drop-down filter that will extract data for the selected item: Note that as soon as I select India from the drop-down filter, all the records for India are extracted.ĭownload the Example File Extract Data from Drop Down List Selection in Excel As soon as I select any country from the drop-down, the data for that country gets extracted to the right. In this tutorial, I will show you how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down.Īs shown in the pic below, I have a created a drop-down list with country names. ![]() Watch Video – Extract Data Using a Drop Down List in Excel
0 Comments
Leave a Reply. |