So, I am not a professional Excel user, but I have taken on the task of creating a way for my company to maintain statistics. This is very difficult to explain via text, so I will try my best!
I have a spreadsheet that we maintain for daily activities… We have 5 columns that we enter data into. Two of the columns I have setup for a Validation list. One list has 5 items to choose from, the other has about 20. I have a separate sheet for the list, another sheet for the menu items, and I would like a separate sheet that maintains the monthly stats.
Now, we need to maintain monthly stats from the list of 20 items (which are topics/words and not numbers). The 20 items need to be broken down by the corresponding list of 5 items. I would like to have the stats update as new items are added to the list. Not making any sense?
In the end, I would like the list of 20 items, showing the number of times that the items from the list of 5 occurred.
Maybe I could email someone what I am trying to accomplish? Which may not be possible.
Thanks!
I have a spreadsheet that we maintain for daily activities… We have 5 columns that we enter data into. Two of the columns I have setup for a Validation list. One list has 5 items to choose from, the other has about 20. I have a separate sheet for the list, another sheet for the menu items, and I would like a separate sheet that maintains the monthly stats.
Now, we need to maintain monthly stats from the list of 20 items (which are topics/words and not numbers). The 20 items need to be broken down by the corresponding list of 5 items. I would like to have the stats update as new items are added to the list. Not making any sense?
In the end, I would like the list of 20 items, showing the number of times that the items from the list of 5 occurred.Maybe I could email someone what I am trying to accomplish? Which may not be possible.
Thanks!
