distance gps city to city

iknowu99

iknowu99

Well-known Member
Joined
Dec 26, 2004
Messages
1,158
Office Version
  1. 2016
what is a good way to figure out the miles from one location in cell A1 to another location in cell B1?

Code: 
A1 = 4 Penn Plaza, New York, NY 10001

B1= Central Park, New York, NY

it is preference that the distance is in driving miles
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
Driving miles? You are out of luck unless you are driving a tank. The complexities involved are beyond mere "as the birdy flies" functions.
 
Upvote 0
Just thinking out loud but putting two addresses into Mapquest or Yahoo! Maps etc. -- would probably give you both the miles and the directions...
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Solved
Having trouble with TEXTJOIN and FILTER
Replies
8
Views
2K
KRice
K
J
  • Question Question
Formula results in an ERROR
2
Replies
18
Views
182
MARK858
MARK858
L
  • Solved
Adding time and distance from one worksheet to another if the cities and states match.
Replies
5
Views
544
fjns
F
B
  • Question Question
Changing Cell References in a table
Replies
1
Views
49
Peter_SSs
Peter_SSs
W
  • Question Question
Error In VBA Code
Replies
3
Views
5K
wella86
W

Forum statistics

Threads
1,225,478
Messages
6,185,228
Members
453,283
Latest member
Shortm88

Share this page

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