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
[TABLE="width: 1567"]
<tbody>[TR]
[TD]Store ID[/TD]
[TD]Store Latitude[/TD]
[TD]Store Longitude[/TD]
[TD]Coordinate Precision[/TD]
[TD]Executed Latitude[/TD]
[TD]Executed Longitude[/TD]
[TD]Exec. Coord. Type[/TD]
[TD]Executed Lat/Long Date/Time[/TD]
[TD]Completed Latitude[/TD]
[TD]Completed Longitude[/TD]
[TD]Comp. Coord. Type[/TD]
[TD]Completed Lat/Long Date[/TD]
[TD]Show on Map[/TD]
[/TR]
[TR]
[TD]4065[/TD]
[TD]34.2969730[/TD]
[TD]-77.7931630[/TD]
[TD]Specific Address[/TD]
[TD]34.2954210[/TD]
[TD]-77.7988870[/TD]
[TD]GPS[/TD]
[TD]8/17/2018 10:03:49 AM[/TD]
[TD]34.2950910[/TD]
[TD]-77.7988110[/TD]
[TD]GPS[/TD]
[TD]8/17/2018 10:35:16 AM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1348[/TD]
[TD]34.1455000[/TD]
[TD]-77.8985000[/TD]
[TD]Specific Address[/TD]
[TD]34.1465970[/TD]
[TD]-77.8976840[/TD]
[TD]GPS[/TD]
[TD]8/17/2018 11:52:17 AM[/TD]
[TD]34.1469630[/TD]
[TD]-77.8970590[/TD]
[TD]GPS[/TD]
[TD]8/17/2018 12:21:22 PM[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1567"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.