Hello Excel community.
Have complicated problem and I am stuck with my research.
Original data comes in three columns - 1.) 12 months worth of days. 2.) 20 names 3.) each day a name has assigned 0, 1 or 2 points.
Out of the three columns I created a pivot table - Names in rows, dates in columns and points in values. As it is imperative that the data keeps its integrity – witch day witch name has how many points.
So here is what I need excel to do:
For example let’s take one name – as mentioned above each day it gets assigned zero, one or two points. So the points themselves are one giant string.
I need excel to go through all the points (chronologically according to the dates) and in each cell display the sum of all the previous points.
The goal is so I can see how many points respective name has earned up until the date I am interested.
In the attached file there is an example of original pivot table and the desired one.
I think it can be done by inserting appropriate formula in the Pivot table`s calculated item. But as I don’t know Jack about excel, there might be better and faster ways to work the data and get the results I need. ( as there are 10 sets of tables I need to make)
Bookmarks