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     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.
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

2 comments:

  1. Is there a way to do this very same thing in an Excel worksheet?

    ReplyDelete
  2. Sorry ... can't say, I have not tried to do this using Excel.

    Make It A Great One.
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete