Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.