Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was really fun. Got hung up once I had the equation on how to convert it, started with a messy multirow but saw others using the dynamic replace so learnt about that instead.
I went the Iterative Macro route on this one. I couldn't figure out how to do the mathing steps without having a bunch of Formula expressions which were confusing me to try to think through, so I hit it with a cannon :)
I also appreciate that we didn't have to worry about math Order of Operations