Verifying Longitude and Latitude

nathankayla42911

New Member
Joined
Aug 24, 2018
Messages
3
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 IDStore LatitudeStore LongitudeCoordinate PrecisionExecuted LatitudeExecuted LongitudeExec. Coord. TypeExecuted Lat/Long Date/TimeCompleted LatitudeCompleted LongitudeComp. Coord. TypeCompleted Lat/Long DateShow on Map
406534.2969730-77.7931630Specific Address34.2954210-77.7988870GPS8/17/2018 10:03:49 AM34.2950910-77.7988110GPS8/17/2018 10:35:16 AM
134834.1455000-77.8985000Specific Address34.1465970-77.8976840GPS8/17/2018 11:52:17 AM34.1469630-77.8970590GPS8/17/2018 12:21:22 PM

<tbody>
</tbody>

<tbody>
</tbody>
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,238
Office Version
365
Platform
Windows
Good show. You're welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,114
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top