Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Not quite an answer to this challenge, but if anyone wants to learn a little about iterative macros, I've attached a packaged workflow that makes use of them.
Got to an answer using the multi-row formula tool. I tried sooooo hard to craft an iterative macro for it, but just couldn't get my head around how (I'm new to them). Time to look at what others have done and learn! :)