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 #81: Multi-Level Bill of Materials Problem

OnionKnight
8 - Asteroid

this is my first time to touch Macro.

Sashikumar
8 - Asteroid

Learned from Solution.

Spoiler
ch81.PNG
clmc9601
13 - Pulsar
13 - Pulsar

My solution

mpennington
11 - Bolide

Attached.

 

Spoiler
MP 81.png
rcarog
8 - Asteroid

Solution attached.

Luke_C
17 - Castor
Spoiler
Luke_C_0-1617371358752.png

 

Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1617928267881.png

 

Chantelbbr_1-1617928277248.png

 

BeginnerMindset
8 - Asteroid

Great challenge.  I went with an iterative macro.

 

Spoiler
BeginnerMindset_0-1618238153011.png

 

Spoiler
BeginnerMindset_1-1618238186225.png

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission, I was really struggling with this challenge and did it without macro. 

youngk313
8 - Asteroid

Solution using join. Could use an iterative macro as well.