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

cwkoops
8 - Asteroid

I repurposed a macro I use for BOM records that are structured differently....may have possibly just been easier to start from scratch as dealing with "Labor" (130-000), "Galvanising", and "MS Flat 80x8" gave me difficulty, as they show up in the Part Number column of the output multiple times with different "Full Quantity" values.

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1626200922011.png

 

Maskell_Rascal_1-1626200936815.png

 

Cheers!

Phil

Pang_Hee_Choy
12 - Quasar

try no luck to solve with no macro.

Elias_Nordlinder
11 - Bolide

Should probably go Iterative next time, oh well good exercise, managed it in the end still 🙂

 

Spoiler
Elias_Nordlinder_0-1627312657839.png

 

JoePC
9 - Comet

Solution Attached

Hub119
8 - Asteroid

Solution attached.

ncrlelia
11 - Bolide

Challenge 081

AlexC2
8 - Asteroid

Tried doing it without an iterative macro, pretty challenging!

 

Spoiler
AlexC2_0-1629994424092.png

 

MichelleL
Alteryx
Alteryx

Non-macro route . . .

Erin
9 - Comet

Took a little while, but got it! 

 

Spoiler
BronzeFox_0-1632853449729.png