Have you considered a 'reverse' procedure? Set your descriptive column according to your list but have a numeric column set via formula. Then sort by the numeric column. That would put your descriptive column into the desired order but still let you change that descriptive field.
|