Forum Discussion
Excel Formula help!
Hi,
I’m struggling with a formula to auto add all the outcomes on my spreadsheet register!
I have a drop down box on the end that has 10 different ‘course outcomes’ (all words, no values). I was wanting to create a table at the bottom that would allow me to look and see how many of each ‘outcome’ there is.
Is there a way to do this?
Thanks for the advice all.
I’m struggling with a formula to auto add all the outcomes on my spreadsheet register!
I have a drop down box on the end that has 10 different ‘course outcomes’ (all words, no values). I was wanting to create a table at the bottom that would allow me to look and see how many of each ‘outcome’ there is.
Is there a way to do this?
Thanks for the advice all.
4 Replies
DexTrex Could you please elaborate and perhaps share a workbook that demonstrates the type of data you are dealing with and the outcome desired.
Riny_van_Eekelen Thank you so much, I have attached a copy of the "schedule" that im trying to create, It will be used to book appointments (Approximately 15-20 appointments per half hour slot) per day.
I want it to be as "User friendly" as possible.
Thanks again for your help.
DexTrex Looked at your file and have difficulty to relate it to your original question. And, as such, it has VBA in it. Something I'd rather not get involved in. Sorry.
