Assigning values to drop-down list options
I'm not even sure if Excel can do this...
I have a worksheet with 5 different drop-down lists on it (each with several
options to select from). I want to be able to assign each option a value so
that I can create a cell/formula that will average the values selected.
Can I do this in Excel? How????
|