Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi, I don't know if I can ask questions about the challenge in this forum or If I should be asking somewhere else but I was wondering how the system recognizes the Iterative output from the final one? Does it depend on order or on name? Are there certain rules? I got introduced to macros through this challenge and I'm trying t o understand how it works and how it applies to this challenge particularly.
Thanks in advance!
Laila
Definitely overthought on this one for way too long... Had to peek at solution for a Northern Light. Way simpler than my original attempts.
Extra step to group by count of employee and sort count descending to get output nicely sorted by seniority (assumes role W/highest hierarchy count to CEO is most junior role) .
I ended up making 2 versions 1 hard coded and 1 using a macro.