Forum Discussion
mindy monnig
Jul 16, 2018Copper Contributor
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...
mindy monnig
Jul 16, 2018Copper Contributor
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.
JKPieterse
Jul 17, 2018Silver Contributor
Have a look at the attached file, perhaps it helps?