Data Validation Drop Down List Multiple Selection Without Duplicates. Select multiple items from drop down list. We simply allow a list equal to the name dd reps as shown below.
In the worksheet shown below you can select any month from the drop down list and it overwrites any previous entry in the cell. In the formula control. All that remains is to set up the drop down box with the data validation feature data data validation.
Select a cell s to place the drop down list click data data validation data validation.
All that remains is to set up the drop down box with the data validation feature data data validation. Now the data of the list are unique. In the formula control. Once the workbook is set up as new data is added to the table each period you just need to refresh the pivottable and any new reps will flow through the pivottable into the drop down.
