| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate the distance between 2 postcodes?
Can anyone help with this?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I calculate the distance between 2 postcodes?
Well, the formula is
Dist = Sqr((x2 - x1) ^ 2 + (y2 - y1) ^ 2) for points (x1, y1) to (x2, y2) "Rhys" wrote: Can anyone help with this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I calculate the distance between 2 postcodes?
Rhys,
So you need the latitude/longitude of your post codes to apply Charlie's formula. About 1/2 way down this page http://att.macrumors.com/attachment....6&d=1082113719 there's a list of about 2800 postcodes. NickHK "Rhys" wrote in message ... Can anyone help with this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I calculate the distance between 2 postcodes?
On Wed, 5 Jul 2006 07:24:02 -0700, Rhys
wrote: Can anyone help with this? Google is your friend. I googled distance between zip codes and got a bunch of links. Since you used the term "post codes", I think you might be outside the U.S., so just substitute post for zip and have at it. Good luck. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES | Excel Worksheet Functions | |||
| How to calculate minimum distance between three coordinate with ex | Excel Discussion (Misc queries) | |||
| Can excel calculate Mahalanobis distance? | Excel Discussion (Misc queries) | |||
| calculate time/distance | Excel Programming | |||
| CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS | Excel Worksheet Functions | |||
Linear Mode
