ExcelBanter - Duplication of items from a drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Duplication of items from a drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/168550-duplication-items-drop-down-list.html)

LTaylor

Duplication of items from a drop down list

I have a dropdown list you can choose multiple items from. However, if I
then decide to get rid of one of the choices by deleting it in the formula
bar, it shows back up and duplicates what is left. How can I keep this from
happening?

All times are GMT +1. The time now is 08:39 PM.