Attached is a spreadsheet that hopefully conveys what i am trying to achieve.
I have been trying to come up with formula that will sum up a total until a blank cell or new cell value is seen.
Attached is a spreadsheet that hopefully conveys what i am trying to achieve.
I have been trying to come up with formula that will sum up a total until a blank cell or new cell value is seen.
An option:
Please try in C2 and copy down:Formula:Please Login or Register to view this content.
With Power Query to fill the table.
After that a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks