need help to resolve macro to find distance between two pincodes

[yallamanda.b]

Hi Team,

could you please share the macro to find the Distance between two pin codes

Thanks

 

[Luke M]

What do you mean by distance? The number of rows? The difference in value? The number of columns + rows?

 

[NARAYANK991]

What do you mean by distance? The number of rows? The difference in value? The number of columns + rows?

Hi Luke ,

In India , pin codes are what Zip codes are in the US.

When OP talks of distance , he wants the physical distance , in kms. or miles , between two locations known through their pin codes.

One pin code may designate New Delhi , while another might designate Agra ; the output would be the physical distance between New Delhi and Agra.

Narayan

 

[Belleke]

This perhaps?
It is metric but you can change it to imperial in the code.

 

[Chihiro]

If you have geo coordinate (Lat & Long in decimal) for each pincode. You can use Haversine formula to calculate great-circle distance between two points.

See linked post for UDF.
http://chandoo.org/forum/threads/power-map.31577/#post-187726

If you don't have it, Google API is the way to go like Belleke did.

 

[Luke M]

Hi Luke ,

In India , pin codes are what Zip codes are in the US.

Thanks Narayan. I was very confused at first, but it's much clearer now!

 

[Marc L]

Hi !

Take care of any Google tool limited in number of requests …​

 

[yallamanda.b]

Yes i want to find the Distance in kilo meters as per pincodes like when we select source and destination in google maps it will show kms and time like that i need distance in kms