Challenge #14: Warehouse Distribution

[Rhys_Cooper]

Taxing challenge! Running total tool came in very handy

Spoiler

[Raj]

Solved!

Challanges are always fun to solve.

[vmazur24052020]

Solution without Macro

[nSpire]

Spoiler

 

[Alteralex]

Spoiler

[mshishido]

My solution

[AlexMcData]

Spoiler

 found this challenge quite difficult mostly due to being unfamiliar with multi-row formulas, and was thrown off by the instance where there is one scenario where there is a store missing with no.1 priority. Good challenge overall though. Imagine it may have been easier taking the iterative macro perspective. 

[rkakde]

Non-Macro Solution:

Spoiler