core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Typing in the area to find nearest was something I did not know.
Took a lot of data wrangling. Phew!! Took longer than expected.
Used lots of Multi Formula Row but finally got it
My solution.
Solved.
not bad....just took a bit of time
FYI: To get the mileage correct, you are still delivering items to all locations, even it they required 50 and only get 1.
Solution below!