Challenge #14: Warehouse Distribution

[jusdespommes]

Been a while since my last iterative - nice to be reminded 🙂

Spoiler

[aazimh]

This is my without-macro attempt, but definitely feels clunky - going to try my hand at a macro version now!

[aazimh]

Took a while, but finally got the macro version sorted! Found a cool new tool as well in the X-Ray Browse Macro. 

[ArnavS]

Very similar to solution #1

[Assaf_m]

Solution Attached 🙂

[BSilverblatt]

Thanks for the challenge! This is my solution.

[Parul_Kapoor]

Solution attached.

[mat_budden]

Hi All,

Please find my Result below.

Spoiler

Joined all Tables, Sorted based on Item then Priority, Did a Running total to get the demand up until that store, Used a Multi Row Formula to adjust the available stock then formula to work out supplied stock, Sorted and Removed excess columns.

Thanks

Mat

[RoDO]

My solution

Spoiler

[SamDesk]

Spoiler

Sam