Challenge #12: Creating an HR Hierarchy

[catherineduffy]

My solution:

Spoiler

[jbranaum]

Here is my solution.  Definitely loved this one!  I had to do something similar in SQL to build an HR table for my work.  I ended up using a series of left joins in SQL but it was really fun to see this applied outside of database.

I am still mastering the macros in general.  The solution seems to have a few less tools in the macro.  I think I made mine a bit too complicated, unnecessarily but appreciate the simplicity of the solution.  Also I ended up assigning hierarch using a multirow formula, instead of leveraging the iteration number.

Sleak solution overall and fun problem!!!!

Thanks for the opportunity to learn!

[archietao]

Great exercise! Learned how to create an iterative macro! 

[cgoodman3]

Here's my solution, realised I had done this one a few weeks back but it wasn't on my Google Sheet where I am monitoring how many solutions I've completed.

Spoiler

[Karam]

Great example of the iterative macro!

[SamDesk]

Spoiler

Sam :)

[AlexCox]

Wow, that took a while, but now I know Kung Fu (aka basic macros)

[jssandom]

My solution (non-iterative)

[KevinW]

Spoiler

[Paul-Evans]

This was a good learning reinforcement for iterative macros. I used one for the first time just a few weeks ago.