Longitude and Latitude - Calculating the Distance between 2 different sets of coordinates
New to the forum. Looking for any insight someone might have on the matter,
I have figured out how to calculate the distance between to coordinate points in excel, but I'm having trouble with the following:
I have two different files. Both files contain a list of Latitude and Longitude coordinates. I'm using list A as the target file (which contains zip codes and Latitude/longitude) and List B is the reference file which contains longitude and latitude coordinates
What I'm specifically looking to do is to return the two closest coordinates from the reference file and place them in the target list with the zip codes. both lists contain about 4000 rows.
Any help is appreciated!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1