+ Reply to Thread
Results 1 to 2 of 2

Distance between 2 locations with distance traveled in each country.

  1. #1
    Registered User
    Join Date
    03-13-2020
    Location
    Vilnius
    MS-Off Ver
    365
    Posts
    2

    Distance between 2 locations with distance traveled in each country.

    Hello, so topic is basically what i need to get.
    I have ~300 locations in Europe, and i need to connect each one with distance between them and distance traveled in each country. As i have only 300 unique locations, so writing the coordinates, adresses, postal codes or any other information is easy, so any way of getting location is good for me. I found some tutorials how to calculate location between points and i think they would work, but the key thing here, is that i need to know distance traveled in each country.
    Example: Spain, Barcelona - Swede, Stockholm. Total - 2716km; Spain 162km; France 975km; Luxembourg 45km; Germany 745km; Denmark 215km; Sweden 574km.
    Any way to even get close to that, or any ideas are very welcome!
    Last edited by Denis1994; 04-29-2020 at 07:00 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Distance between 2 locations with distance traveled in each country.

    Some suggestions you may fund useful:
    1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
    2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
    3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
    4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."

+ 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. Calculating total road distance and duration with google distance matrixes api
    By musta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2019, 07:21 AM
  2. Replies: 1
    Last Post: 04-21-2019, 03:31 AM
  3. Can I use a formula for distance traveled? Thank you.
    By Zach Boyer in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-29-2016, 04:31 PM
  4. Assigning locations by distance
    By some_one_hd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2015, 11:39 AM
  5. [SOLVED] Finding the distance between two GPS locations
    By Notsoexcelwizard in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-05-2015, 06:35 AM
  6. Distance Between Two Locations
    By Zan03 in forum Excel General
    Replies: 4
    Last Post: 05-04-2010, 02:40 PM
  7. Loop/Array to Determine average distance traveled
    By Kwagga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2008, 05:19 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