+ Reply to Thread
Results 1 to 6 of 6

Distance calculate between 2 UK Postcodes

  1. #1
    Registered User
    Join Date
    12-06-2016
    Location
    Poole
    MS-Off Ver
    MS 365 Subscription, Vers. 2310
    Posts
    84

    Distance calculate between 2 UK Postcodes

    Hi.

    I've just got a new job and I need to make an excel database for employees and find out whats it the distance (as the crow flies) from our workplace. I have searched high and low for a solution but came out empty handed every time. I was wondering if someone has done this before? The way i see it:

    Col A B C D
    Name Postcode 1 Postcode 2 Distance

    Any kind of help would be much appreciate it.
    Cheers

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Distance calculate between 2 UK Postcodes

    in column what data you have mentioned. Plz upload samply file to get clear idea.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    12-06-2016
    Location
    Poole
    MS-Off Ver
    MS 365 Subscription, Vers. 2310
    Posts
    84

    Re: Distance calculate between 2 UK Postcodes

    I have attached a small example of what I am trying to achieve.New Microsoft Excel Worksheet.xlsx

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Distance calculate between 2 UK Postcodes

    This will get you driving distance:
    http://www.excelforum.com/tips-and-t...rivetimes.html

    If you want the distance as the crow trundles, it's a 2 step affair. Firstly you need to geocode all your postcodes - so convert them to lat and long. Once you've done that you can use a formula to get you the distance between them.

    I don't know of a free geocoding service that's any good for uk postcodes (very accurate anyway), if you only need very rough, have a look at http://postcodes.io/, we use a paid service by http://www.pcapredict.com/en-gb/index/ which is very good, but you get what you pay for.

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Distance calculate between 2 UK Postcodes

    i have solution, but only those BH15, BH3, BH1, BH5, BH11 start with.

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Distance calculate between 2 UK Postcodes

    See my attachment in this thread:

    http://www.excelforum.com/excel-tips...alculator.html

    It's a few years old, and I haven't updated the lookup table, but it shows you how you can do it.

    Hope this helps.

    Pete

+ 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. Excel - Google maps. Distance between two postcodes
    By pauldaddyadams in forum Excel General
    Replies: 2
    Last Post: 12-04-2015, 01:32 PM
  2. Two postcodes on databse to return distance?
    By samuelleach in forum Excel General
    Replies: 6
    Last Post: 02-05-2015, 03:47 PM
  3. Distance to many UK postcodes
    By samcdavies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2014, 12:13 PM
  4. Excel SpreadSheet to Calculate the Distance between UK postcodes
    By RachaelDonelon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 05:08 AM
  5. Distance between UK postcodes
    By peterpcu in forum Excel General
    Replies: 13
    Last Post: 12-31-2011, 12:11 PM
  6. VBA to calculate distance between Uk Postcodes - Urgent help
    By JasonHopkins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2011, 12:26 PM
  7. How do I calculate the distance between 2 postcodes?
    By Rhys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2006, 03:30 PM

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