Problem

Given the latitude and longitude of selected cities, create a table that gives the distance between any two of the listed cities.

Solution

1. With raw data highlighted in green, I first created a grid of all the cities. The horizontal row was Transpose pasted over
2. In cell H4, I used the formula
3. Copy and pasted the above formula over the entire table (highlighted in blue)