Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASlightly different from the provided solution.
I used a Multi-Row formula to arrive at the Running Total instead of Running Total tool and used a separate formula for values < 0 to be marked as ZERO as compared to the same nested IF formula. Good Learning!!!!
The solving thrill continues!!!!!!!!!!!!!!!!
Here's my no macro solution:
I'll attach a macro version shortly.
I wish the second solution could be update though, would be interested to see the 'official' macro-based solution.
The second solution file attached is actually for challenge 11, not 14, so I compared my workflow to others, and it seems pretty similar to @NicoleJohnson's!