Verifying Longitude and Latitude

[nathankayla42911]

I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and red for far away. If someone could point me in the right direction or maybe someone who can solve.


A B C D E F G H I J K

Store ID

Store Latitude

Store Longitude

Coordinate Precision

Executed Latitude

Executed Longitude

Exec. Coord. Type

Executed Lat/Long Date/Time

Completed Latitude

Completed Longitude

Comp. Coord. Type

Completed Lat/Long Date

Show on Map

4065

34.2969730

-77.7931630

Specific Address

34.2954210

-77.7988870

GPS

8/17/2018 10:03:49 AM

34.2950910

-77.7988110

GPS

8/17/2018 10:35:16 AM

1348

34.1455000

-77.8985000

Specific Address

34.1465970

-77.8976840

GPS

8/17/2018 11:52:17 AM

34.1469630

-77.8970590

GPS

8/17/2018 12:21:22 PM

<tbody>
</tbody>

<tbody>
</tbody>

 

[DRSteele]

Welcome to the forum.

I suspect that perusing this and its included links will help you determine the Great Circle Distances between LatLong coordinates.
https://www.mrexcel.com/forum/excel...etween-1000-latitude-longitude-addresses.html

 

[nathankayla42911]

I found solution earlier but yes that is similar to the solution I found. Thanks,

 

[nathankayla42911]

DRSteele helped with solution thanks all problem has been solved.

 

[DRSteele]

Good show. You're welcome.