Challenge #48: Calculating Distribution Priority

[simbert]

That took longer than expected and I may have made my life more complicated than it should...

[SamDesk]

Spoiler

Sam 🙂

[AkimasaKajitani]

My solution.

Spoiler

[jeng]

Spoiler

[Pang_Hee_Choy]

attach

[jessle]

Overcomplicated this one to the point of ridiculousness... but once I'd started I couldn't stop! 

Used an iterative macro but glad to see there's simpler solutions 🙂

Spoiler

[rajatsadan]

@GeneR  Interesting challenge !! 

I tried to solve using formula and filter conditions, however my answers are not matching with the solutions for first and third questions. 

Could someone explain where I went wrong?? Much appreciate!

[Billigans]

Spoiler

[Qiu]

Fun one!

Spoiler

[MohitBasia]

Spoiler

Here is my solution