+ Reply to Thread
Results 1 to 2 of 2

Distance between 2 addresses

  1. #1
    Registered User
    Join Date
    12-20-2014
    Location
    chicago
    MS-Off Ver
    Office 2013
    Posts
    10

    Exclamation Distance between 2 addresses

    Hey,

    need a formula or SOME way to calculate the distance between two addresses!


    column A=name of place (ex: HOME)
    columb B=address (1234 n excel st, city, state, zip code)
    column C= address (4321 s forum avenue,city,state,zip code)


    WANT
    COLUMN D= distance between b and c
    column E= (if column A = HOME , then column E is some text assigned to that name in column A)



    column A column B column C column D column E
    steakhouse address 2nd address distance between B and C (if A=home then e=1, if A=steak then 2, etc.. )
    home
    seafood
    home
    home
    etc.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Distance between 2 addresses

    Look at this link and see if it helps

    http://community.spiceworks.com/topi...esses-in-excel
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating distance between many GPS points and sorting by distance
    By jackalek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-14-2014, 08:27 AM
  2. [SOLVED] Google Distance Matrix API - Distance and Time
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 08:42 PM
  3. [SOLVED] Edit distance (Levenshtein Distance) using Excel
    By cool_anu4u in forum Excel General
    Replies: 4
    Last Post: 10-09-2013, 08:46 AM
  4. [SOLVED] retrive the distance between any two cities from distance table
    By rksundaram in forum Excel General
    Replies: 5
    Last Post: 08-22-2013, 11:46 PM
  5. Replies: 0
    Last Post: 08-25-2005, 02:58 AM

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