Challenge #14: Warehouse Distribution

[WegmanJordy]

Hereby the solution.

[sonyakasenkramer]

Spoiler

[andyjohnstone2]

Took quite a few hours but managed with a standard macro end multi row formulas in the end.

[JackParry]

Solution

[dark_a]

This one was interesting, but kind of easy. Thanks for good one.

🙂P.S. before version was uploaded without saving 🙂

[djodts]

My solution

[rsomani005]

This was a good practice to try out the multi-row formula with grouping. My approach was as follows:

• Lookup the store priority into the store and item-wise demand sheet and sorting basis item and priority
• Lookup the item-wise initial stock in the warehouse
• Create a running total of item requirement with a grouping on item 
• Using a multi-row tool to restrict the overall requirement of a material to the initial stock 
• Using the multi-row tool again to backout the demand for each store 

[kmcdaniel]

Great practice building an iterative macro!

Spoiler

[Joe_McCoy]

I went the no macro route.