I need help Caculating Zip code Distances
Could someone please help me, I want to create a formula that will caculate
the distance between two zip codes. I was not sure if I do what you to to caculate the number between two dates. |
I need help Caculating Zip code Distances
It can't be done like dates since Zip codes have no fixed distance between
numeric values. You would need to obtain a table somewhere - try an internet search - that would either give the distances for any pair of codes (would be a pretty big table!) or perhaps would give latitude/longitude, then you would need to find someone who knows a formula to convert differences in lat/longitude to differences in miles. It will not be an easy task, I'm afraid. -- - K Dales "Dougal" wrote: Could someone please help me, I want to create a formula that will caculate the distance between two zip codes. I was not sure if I do what you to to caculate the number between two dates. |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com