+ Reply to Thread
Results 1 to 5 of 5

Calculate distance

  1. 05-09-2013, 02:07 AM #1
    mukesh mishra
    mukesh mishra is offline
    Registered User
    Join Date
    05-08-2013
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    3

    Calculate distance

    I have two coordiante list in excel, and i want to calculate distance between each coordinate in once.

    Pls help.
    Reply With QuoteRegister To Reply
  2. 05-09-2013, 05:11 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,720

    Re: Calculate distance

    Are your coordinates like X and Y, or latitude and longitude?

    Pete
    Reply With QuoteRegister To Reply
  3. 05-09-2013, 05:22 AM #3
    mukesh mishra
    mukesh mishra is offline
    Registered User
    Join Date
    05-08-2013
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Calculate distance

    x, y coordiante
    mukesh
    Reply With QuoteRegister To Reply
  4. 05-09-2013, 05:44 AM #4
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Calculate distance

    Hi mukesh mishra

    Point1
    x1 = 345
    y1 = 100

    Point2
    x2 = 100
    y2 = 100

    =SQRT((x1-x2)^2+(y1-y2)^2)

    Do you need the bearing!
    Last edited by Kevin UK; 05-09-2013 at 05:47 AM.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
  5. 05-09-2013, 06:23 AM #5
    mukesh mishra
    mukesh mishra is offline
    Registered User
    Join Date
    05-08-2013
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Calculate distance

    thanks kevin,
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1