Driving Distance between two points.

gsmitchell

New Member
Joined
Feb 11, 2006
Messages
35
Hello All, Good Morning!

I am going to have a long list ( 1000+ ) of addresses that I need to get driving distances for. I don't need a map, just the distance between two specific addresses ( not just zip codes ). I have seen some info on zip codes and some using long/lat on here, but most of it is giving an "as the bird flies" result. We can get those done, but find they are not quite granular enough for our needs. Has anyone had any luck trying to get something like this done? Any help appreciated, thanks!

George
 
Hi Everyone! I think the Google API solution is going to work best for my needs. Thanks to everyone that replied with a suggestion for this, it is much appreciated!
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
ya, probably you're best bet to go with something like that. you could certainly do it with excel/vba but the database you would have to build would be huge and take a really long time
 
Upvote 0

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top