Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution. answers using Distance and Find Nearest are not the same, but I can't figure out what makes the outcomes different.
Also got a different (better :D) solution for question2.
Not very happy with how I handled the iterations with this approach but it gets the job done
Agreed about the smaller "closest distance" answer!
Very simple solution using an iterative macro that also gets the shorter correct distance. Comments added to help those that might be struggling.