Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy Solution
This is basically what I did as well.
Definitely added complexity by avoiding putting all the logic in the formula and generate rows tools
Fun challenge, got to use some stuff I picked up at inspire too!
Super fun way to solve this challenge! I love that your solution scales well with a much larger data set. I was lazy. :)
Note: To check your solution, replace the value of 720 with 100 in the first row and see the result. If you get a negative number, your formula is wrong. 😉
Two tool solution! Also sub five minutes - practicing for the next Grand Prix 😉