=unique (a2:a21) optionally, you can sort.

How to add drop down list in excel file. To extract the unique items, use this formula: Web select a cell in which you want the dropdown to appear (d3 in our case). On the data tab, in the data tools group, click data validation.

Web to insert a drop down list in excel, you use the data validation feature. Web on the ribbon, click data > data validation. Edit, copy, delete, add or remove items without changing the data.

Web add a list box to your excel worksheet from which users can choose a value. Select the data tools group from the data tab. In the data validation dialog.

Web you aim to add a dropdown list where each item appears just once. The cleanest way to set something like this up is to create a new tab in excel where you can configure all of. The steps slightly vary depending on whether the source items are in a regular range,.

Web select the cell or cells where you want to create a dropdown list. You can add or delete items from your drop. Select the data you want to use and type a name for it in the name.

Make data entry easier by letting users choose a value from a combo box.