Sorting GPS location data in an Excel Sheet

finding the distance between each pair of points as the crow flies will not be a big deal (you may see for instance distance calculation in this post: https://www.excelforum.com/excel-pro...ml#post3622321 ) .

But sorting them in a sequence that makes shortest total length is a quite computing time intensive problem. see https://en.wikipedia.org/wiki/Travel...lesman_problem
soem insight can be also found in several posts on our forum. First I noted: https://www.excelforum.com/excel-gen...algorithm.html You may use "similar threads" window when reading the above mentioned one