Sorting the Latitude and Longitude Data and Calculating Distance

Hello,

This is my first post in the forum .I am looking for a stepwise approach to sort the latitude and longitude of multiple geo points and calculate the distance between the two closed points in ascending order and also calculate the total distance of the entire route in Km's. My Data is attached

Thanks in advance

I >>think<< this is what you want (complicated by the fact that you provided a very limited explanation and NO expected answers!!)

In D3, copied down:
=101.12 * SQRT(((B3 - B2) * COS(RADIANS(C2)))^2 + (C3 - C2)^2)

I cannot answer as I really don't know what you're trying to do... your explanation was minimal.

Is this a "shortest path" or "traveling salesman" kind of problem?

Here's a "shortest path" problem that finds the shortest path through a series of nodes but not necessarily visiting each node: https://www.excel-easy.com/examples/...h-problem.html

Here's a "traveling salesman" tutorial that uses Excel's Solver to find the shortest path through all nodes: http://blog.excelmasterseries.com/20...blem-with.html

Do either of those problems look like the kind of problem you are trying to solve?

If it helps, here's another tutorial for the traveling salesperson problem: https://medium.com/@rihot_gusron/sol...m-e8deea89ca42 I found several other tutorials with a search string like "traveling salesman problem Excel."

I note that every Excel based tutorial that I am finding begins with building a distance matrix somewhere in the spreadsheet. I note that your sample file does not include a distance matrix anywhere, so it would appear that you should start there. How are you wanting to calculate distance between nodes? Can you build a matrix that calculates the distance between all nodes?