Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Spent 10 minutes trying to figure out why my sum was wrong only to see that I had everything coming out of the "false" anchor from my filter...
my solution! very funny one!
Agree with @dsmdavid , we maybe need to consider when to restrict the 30 closest locations, which brings different result.
Could you please throw some light on Macro? What macro is doing and how it is finding the next delivery location? I would really appreciate your help on this.
Hi. Attached is my solution. I did both the original approach and @dsmdavid 's approach. I would prefer the latter as the round trip itself is less than 56 miles
Hard but fun ! 🙂
Iterative macro :
Made two option.
<Option2 : Closest to shop>
<Workflow: Upper-Option1, Lower-Option2>