Web you aim to add a dropdown list where each item appears just once.
How to add drop down list in excel data entry form. Select the data tools group from the data tab. You can add or delete items from your drop. To extract the unique items, use this formula:
Make sure the items are consecutive (no blank rows). To remove an item, press delete. Select a cell in which you want the dropdown to appear (d3 in our case).
This is useful when you need to enter a set list of employees, products, part. Web to add an item, go to the end of the list and type the new item. Web excel data entry form;
Add the form tool to excel;