Calculate Distance between two addresses without API

[ardykav]

I had some code years ago which allowed me to enter a formula eg =getdistance(A1,B1) in a cell and it would calculate the distance between two addresses. Would anyone know if this is still able to be used or where I could find it?

thanks

 

[Toadstool]

Hi Ardykav,

I don't see how actual distance could be calculated without some kind of API to a mapping tool but you can approximate direct distance given two longitude and latitude co-ordinates.

Ardykav-Distance.xlsx
	A	B	C	D
1	Latitude	Longitude	Place	Distance (kms)
2	51.50776	-0.12793	Nelson's Column, London
3	54.91255	-1.58621	Angel of the North, Gateshead	390.8275689
Sheet4

Cell Formulas
Range	Formula
D3	D3	=ACOS(COS(RADIANS(90-A3)) *COS(RADIANS(90-A2)) +SIN(RADIANS(90-A3)) *SIN(RADIANS(90-A2)) *COS(RADIANS(B3-B2))) *6371

 

[ardykav]

Yeah I thought as much too but it definitely worked a few years ago although it was about 7 years back now. Regards the lat long thats great, is there a quick way of bringing the lat long in or is that an API job too?

thanks for responding,

 

[Toadstool]

You can get individual Longitude & Latitude from Google Maps.
Some years ago I used some online batch conversion services to convert addresses and another to convert postcodes but I can't remember the URLs.

 

[kweaver]

I've used the same trig formula that Toadstool proposed and it works find (at least for the need I had).
I also used this fairly large file (options include CSV, Excel, etc.) with zip codes (43,000+) and the respective longitude and latitude.
Hope this is helpful.

US Zip Code Latitude and Longitude

 

[ardykav]

I've used the same trig formula that Toadstool proposed and it works find (at least for the need I had).
I also used this fairly large file (options include CSV, Excel, etc.) with zip codes (43,000+) and the respective longitude and latitude.
Hope this is helpful.

US Zip Code Latitude and Longitude

Thanks a lot for that very helpful