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! :)