Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAWith a runtime of 0.4 seconds I figured just about any efficiency would work.
Solved. Wow. This was a pain in the **bleep**. :)
Used an iterative macro which I am super rusty on. Took forever to get it to work. It is ugly but it works. Probably very far from the most efficient way to do it, but again it works. Spoiler shows screenshot of macro
Sort Tool is useless in there, so just ignore that. 😀
Wow, this took me forever.
Didnt think of the running total approach as i've now seen in many other solution.
Used a iterative macro inside a batch macro. Batching the accounts into an iterative macro which iterates as many times as there are transactions.
interesting challenge
I really should get more comfortable using the Running Total tool, it is just not something I go to often. Here is my batch macro approach.