Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #605 Jul 1, 2012 www.energyefficientbuild.com.
user teadby said:
How do i calculate driving distance in miles from postcode to postcode in spreadsheet?
I want to automatically calculate the diving distance between a list of 2 United Kingdom postcodes in Google spreadsheet.
-----------------------------------------------------------------------
following is a solution to the problem
user teadby said:
How do i calculate driving distance in miles from postcode to postcode in spreadsheet?
I want to automatically calculate the diving distance between a list of 2 United Kingdom postcodes in Google spreadsheet.
Column A contains the FROM postcodes and Column B contains the TO postcodes. I want the results to appear in column C in miles
There are column headers so the FROM codes start in A2 continuing down and the TO codes start in B2.
i want the distance in miles results for A2 to B2, A3 to B3, A4 to B4 etc etc in an array that continues down each row of column C that has an entry in the TO column (column B) in that row.
Is there a way of doing this? Using Google maps maybe?
-----------------------------------------------------------------------
following is a solution to the problem
Is there a way to do this very same thing in an Excel worksheet?
ReplyDeleteSorry ... can't say, I have not tried to do this using Excel.
ReplyDeleteMake It A Great One.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com