Sunday, July 1, 2012

yogi_Compute Distance Between Sets Of 2 Postcodes In United Kingdom

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #605   Jul 1, 2012

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