Forum Discussion
dithering a choice in excel
I have self taught myself many functions in Excel but am struggling with one last task I would like to complete. I have a worksheet I have created that have four columns to choose from 1, 2, 3 and N...
WHy not have just one column with a drop-down in the cell where the user picks 1, 2, 3 or NA? You can use Data Validation for that purpose with the List option.
Thanks for the response. It is because I am counting the number of items chosen in each column then timing by a multiplier and then multiplying by a another number. I couldn't figure out how to the calculation with a drop down option. I am certain there is a way I am just not smart enough to figure it out.
Have a look at the attached file, perhaps it helps?
