Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEABoggled my noggin for a while! 🤓
Solved! My first thought was an iterative macro but since this is marked as Basic/Core, I went with a more Basic/Core solution :)
I think the wording of this challenge is a bit more confusing than intended. Once I started analyzing the output, it became clearer. Either way, great chance to practice multi-row formulae!
Figured it would be interesting to try to avoid an iterative/batch macro....
My Image uploads are still bugged, but i was able to leverage a multi-row formula to do the calculations after pivoting. Likely not the way I would do it in a practical setting and I would typically opt for an iterative macro.