Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFun challenge and a great way to practice configuring multi-row formulas:
Tried to do it with a iterative macro. It gave a little headache but It is finally done.
Having trouble with controlling the iterations in the macro, but when I use the AMP engine, it completes in less than a second anyway, so I'm calling it good for now.
My solution
Opened this one up for some macro practise before quickly realising that I could do it easily without.