You also can remove the duplicates from the table list firstly, then create the drop down list.ġ. Now the drop down list without duplicates has been created. In the Data Validation dialog, select List in Allow list under Settings tab, select the PivotTable list as the Source data.ĥ. Select a cell(s) to place the drop down list, click Data > Data Validation > Data Validation.Ĥ. Click OK, then in the PivotTable Fields pane, drag the column you want to create drop down list based on to the Rows section.ģ. ![]() Select the table, click Insert > PivotTable, then choose a position for the new PivotTable.Ģ. You can create a PivotTable based on the table first, then create drop-down list based on the PivotTable.ġ. Supposing you want to create a drop- down list based on a list of a table contains some duplicate values, how can you exclude these duplicates in the drop-down list in Excel?Actually, there are three methods can help you.Ĭreate drop down list without duplicates by using PivotTableĬreate drop down list without duplicates by using Remove DuplicatesĬreate drop down list without duplicates by using Kutools for Excel How to create a drop-down list from a table without duplicate in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |