This will appear in the Remove Duplicates dialog box.After that, go to the Data tab from the ribbon.Secondly, paste the selected countries at any of the other cells in the worksheet.Firstly, select the counties which are in column D.To do so, let’s have a look at the steps below. We will make a unique list of the countries. So, here we have a dataset that contains some product id in column B, the name of the products in column C, and the county name in column D. In this method, we will see how to extract data or filter data based on a drop-down list selection in excel. Excel Drop Down List Filter to Extract Data Read more: How to Create Dependent Drop Down List in ExcelĢ. If we need to make changes to data, we can quickly do that.Now, we can easily make a list of who is selected.Our selected cells are now drop-down list boxes. We will write Yes, No, Not Decided Yet in the source box. Now, click on the drop-down menu under Allow.In the Settings option, we can see the Validation criteria.This will open up the Data Validation dialog box.Fourth, select the Data Validation from the drop-down menu.Third, we need to go to the Data Validation drop-down menu.Second, click on the Data tab on the ribbon.First, select the cells where we want to create the drop-down list filter.

To do this, we need to follow the steps below. We will create a drop-down list filter to make the work done easily. Now, we want to make a list of the candidates if they are selected or not in column C.

The dataset contains some candidate names in column B. For this, we are going to use the dataset below.

In this method, we will see how we can create a drop-down list filter. Let’s have a look at some easy ways to create excel drop-down list filter. 7 Different Ways of Creating Drop Down List with Filter in Excelįiltering differs from grouping in that it allows us to qualify and show just the information that is relevant to us.

How to add drop down menu in excel 2016