Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have problem creating formula referencing a drop down list, can someone help?
Example: In the drop down list, there a 1-Below Average 2-Average 3-Good 4-Excellent 1 is given 1 point, 2 given 2 points, 3 given 3 points and 4 given 4 points. Assume there are 3 drop down list, all drop down list has 3-Good. So the mean should be (3+3+3)/3 = 3 How do I create a formula that will calculate the mean? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing a data validation list | Excel Discussion (Misc queries) | |||
Missing Drop Down list -Data Validation | Excel Discussion (Misc queries) | |||
Drop down list box width - data validation | Excel Discussion (Misc queries) | |||
Drop down list in Data Validation | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |