Hi Excel Gurus,
I want to create a drop down list with a set of values in a range from 1 to 5 but I also want the user to have an explanation of what the range means. E.g"
1 - Very Low
2. - Low
3 - Medium
4 - High
5 - Very High.
I want to show the above in the drop down list. However after the user selects and option I would like the number (1-5) only to be stored in the cell. The reasons for this is I would like to some analysis on the enter numeric scores.
Any assistance will be greatly appreciated.
I want to create a drop down list with a set of values in a range from 1 to 5 but I also want the user to have an explanation of what the range means. E.g"
1 - Very Low
2. - Low
3 - Medium
4 - High
5 - Very High.
I want to show the above in the drop down list. However after the user selects and option I would like the number (1-5) only to be stored in the cell. The reasons for this is I would like to some analysis on the enter numeric scores.
Any assistance will be greatly appreciated.