+ Reply to Thread
Results 1 to 6 of 6

retrive the distance between any two cities from distance table

  1. #1
    Registered User
    Join Date
    01-22-2007
    Posts
    2

    Post retrive the distance between any two cities from distance table

    I have sheet containing Distances between(137) cities need to know a formula to retrive the same in a new sheet by just feeding the city names.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-28-2006
    Posts
    45
    This should do it I think

    Cheers

    Tom
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Hi check it out
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-22-2007
    Posts
    2

    retrive the distanxes between any two coties from distance table

    Thanks to starguy and tom moston for their suggestions solves my problem.

    R K Sundaram

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: retrive the distance between any two cities from distance table

    Thanks to both of you for sharing your solutions (and to the original poster for their question)! I had the exact same challenge, but with fewer cities.

  6. #6
    Registered User
    Join Date
    08-22-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: retrive the distance between any two cities from distance table

    Digging up an old thread here, lol! But I came across a similar challenge, and here is how I managed to solve it.

    I used MS Excel 2010, so please beware of any compatibility issues before proceeding!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1