Using excel to map or match addresses by zip code or miles

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Using excel to map or match addresses by zip code or miles

  1. #1
    Board Regular
    Join Date
    Mar 2014
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Using excel to map or match addresses by zip code or miles

     
    I have different addresses on different worksheets within the same workbook. Each worksheet represents a different hotel flagship (so comfort inn, holiday inn, ect). I'd like a way to match different hotels that are located near each other within excel. The only logical thing I can think of is to match cities and zip codes. Is there another way to see who is located near each other by miles within excel? What formulas would you use to start matching up locations? Thank you.

  2. #2
    Board Regular Rijnsent's Avatar
    Join Date
    Oct 2005
    Location
    Utrecht, Holland
    Posts
    861
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using excel to map or match addresses by zip code or miles

      
    Hi Diana,

    depending how complex you want to make it I guess the Google Maps API might be your best friend, maybe like this:
    Google Maps distance function for Excel | oCoCarbon
    or like this:
    Distance between postcodes (Using Excel and Google Maps API) - Glen Gilchrist

    Cheers,

    Koen
    You can't post attachments here, but you can help me helping you by posting a screen shot directly in your post with any of those tools.
    And although it's against forum rules, otherwise use dropbox/google drive/etc to get your file accross.
    Finally, please show that you made an effort to solve your problem: Yes, I like to help, but am not going to do your job.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com