Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #12: Creating an HR Hierarchy

AllexJia
8 - Asteroid

Finishing this chanllenge gives me a  better understanding of iteration macro!Thx a lot !

apathetichell
18 - Pollux

Non-macro version...

Maskell_Rascal
13 - Pulsar

Here is my solution

Spoiler
Maskell_Rascal_0-1618868791092.pngMaskell_Rascal_1-1618868802226.png

 

realdaniel1989
8 - Asteroid
Spoiler
realdaniel1989_0-1619173202518.png

 

ENix
8 - Asteroid
Spoiler
ElliottNix_0-1619204366357.png
Spoiler
Spoiler
ElliottNix_1-1619204395765.png

 

RashedDS
8 - Asteroid

My solution

 

Spoiler
week12.JPG

 

week 12- macro.JPG

 

Mario36
8 - Asteroid

Here's my solution. Well, I've seen quite a few solutions with macros being used.

I've solved it the non macro way and kept it simple.

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

I need to look into different challenges about macros to upskill a bit. 

 

Emil_Kos_0-1622872330273.png

 

sara_burk
7 - Meteor
Spoiler
sara_burk_0-1623524238847.png

 

Great macro practice!

youngk313
8 - Asteroid

Two solutions: one using an iterative macro and one using generate rows and multi-row formula.