If you want to measure a distance between any two points, there is an Excel formula that does just that. For that you solely need the coordinates of locations (Latitude, Longitude) and a blank Excel worksheet.

The formula for measuring the distance is as follows:

=6371 * ACOS(SIN([latitude of 1st location]*PI()/180)*SIN([latitude of 2nd location]*PI()/180) + COS([latitude of 1st location]*PI()/180) * COS([latitude of 2nd location]*PI()/180)*COS([longitude of 2nd location]* PI()/180-[longitude of 1st location] *PI()/180))

Example

Let's say we want to calculate the distance to the famous Cologne Musical Dome Theater from few locations in Germany.

• in Cells F4 and F5, we fill out Latitude and Longitude of the Dome Theater.
• we make a table with multiple locations from which we want to calculate the distance to the Musical Dome.
• Enter the long formula described above referencing to the latitude and longitude in the table.
• Voila! We have the list of distances to the Musical Dome.

#excel #formula #distance #dataempower