Duplicate Values in column

Gina Brummels

I am having an issue with a sheet where we had changed some of the values in the dropdown of column properties, but because the old values were used previously, unless a user selects the dropdown, they can start typing and select the old value. 

It creates an issue when trying to analyze the data. even when we override the incorrect options, they still show up for users to select when typing. 

Any suggestions would be great

Gina

J. Craig Williams

Gina,

 

Change the Dropdown list and the column at the same time (meaning very quickly after doing the first)

 

1. fix drop down list 

2. filter for the incorrect value and change them all

3. save

4. repeat

 

That fixes the source (the dropdown) and old values (in the column)

 

I hope that helps.

 

Craig