We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #14: Warehouse Distribution

Ramesh_Neel
11 - Bolide

My solution with running total

NicolasSz
9 - Comet

My solution. Very similar to the one proposed except that I used a multi row formula to compute the remaining available stock instead of the running that compute the total stock required.

Interesting one ! Thanks

benjimoser
8 - Asteroid

My Solution.

 

Spoiler
benjimoser_0-1668523753502.png

 

weronika_wiera
5 - Atom

this took me whole day >D

Gem
8 - Asteroid

I had trouble with this one at first, and I'm glad I didn't give up! Iterative been a real shame if I'd missed out on this challenge! 

lugesy
8 - Asteroid
Spoiler
14_workflow.png

 

At first, I've used running totals rather than macros. Then I've also found the same solution set using iterative macros. First solution is attached.

TimN
11 - Bolide

the non-macro solution.

 

 

JosephAskew
7 - Meteor

A bit different from the actual solution, but I got ther. 

pmyers
Alteryx
Alteryx
Spoiler
pmyers_0-1668958968498.png

 

bobd
8 - Asteroid

my solutions