Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution:
It took a couple of minutes to think about what tools I would need to figure this out.
The Multi Row Formula was super extremely useful to solve this problem since it has access to the information in the previous row!