In Google sheets, I have a drop down list with a list of items criteria. Approved,Pending,Rejected,Met,Over,Under,No Actual Originally the list was . . . No Actual,Over,Under,Approved,Pending,Rejected,Met This validation is in a sequence of several rows in a column. No matter what I do, when I press the drop-down arrow, sometimes the original list displays in the drop down and sometimes the old list displays. I have copied one of the correct cells and removed then recreated the list, and the drop-down won't present the list as shown in the criteria list. The criteria list is correct but the drop-down list is incorrect. Please help.
Solved by S. Q. in 25 mins