Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I'm with you, TurboToad. I couldn't figure out why I needed a macro and also removed an if statement by concluding 0 resources needed was a "Yes".
Tool golf! (4 tools)
My try! Also did it without macro.
Why do we consider Period 9 in East as an one unmet requirement? With zero resources needed and no resources allocated, it is a perfect match for me.
I found it tricky to understand the resource usage. Perhaps it is a product like a software free trial - that may explain why it could be used in multiple regions but only once per region.
I also agree with several of the users above that when 0 resources are needed, the need is met regardless of the resource availability.
Initial workflow
Batch macro
Iterative macro
My solution witout macro.
Was going to say it like it was Butch Cassidy and the Sundance kid: "Macro? We don't need no stinking macro"
But it seems, that's the majority of the consensus, I didn't see a need either. Short, sweet, clear, simple.
I agree with someone else who posted about "0 needed" being no, I actually labeled them N/A.
My solution without macro.
(It would be simpler to use the GetPart function, but my version did not have it)