Sorting Locations

wutzke

New Member
Joined
Nov 2, 2011
Messages
1
I have a several rows of addresses in one column followed by lat/long in the next columns.

a 416 Snider Avenue SE, Olympa, WA 47.0354605 -122.9030842
b 1315 10th Street, Sacramento, CA 38.576927 -121.4949038
c 900 Court Street Northeast, Salem, Oregon 44.9390127 -123.0300577
d 700 W Jefferson St, Boise, Idaho 43.617729 -116.199671
e 500 E Capitol Ave., Pierre, SD 44.3670868 -100.3463526


I can to find the distance between each address.

a b 588.743116389392
a c 144.978695243899
a d 402.00802354729
a e 1099.99623703835

b c 446.617373142927
b d 444.000790201019
b e 1161.62065386293

c d 349.877894143379
c e 1111.99612338077

d e 788.49920907168


I want to then sort the results so that I find the shortest routes between each address, first and then route a tour of all addresses. "a" would be the starting point.


drivingrouteplanner.com sorts it this way
a 416 Snider Avenue SE, Olympa, WA
c 900 Court Street Northeast, Salem, Oregon
b 1315 10th Street Sacramento, CA
d 700 W Jefferson St, Boise, Idaho
e 500 E Capitol Ave., Pierre, SD

and drivingrouteplanner.com also says this route is shortest
a 416 Snider Avenue SE, Olympa, WA
e 500 E Capitol Ave., Pierre, SD
d 700 W Jefferson St, Boise, Idaho
b 1315 10th Street Sacramento, CA
c 900 Court Street Northeast, Salem, Oregon

What loop do you think would sort logically, finding the shortest route?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top