+ Reply to Thread
Results 1 to 3 of 3

Nearest coordinates 3d distance - surveyor

  1. #1
    Registered User
    Join Date
    08-25-2021
    Location
    London, England
    MS-Off Ver
    2020
    Posts
    4

    Nearest coordinates 3d distance - surveyor

    Hello All

    I'm surveyor and we are processing big amount of the survey data. We have to simplify a bit coordinates search by finding the nearest points to the design. Depends of the type of surveyed item we need only 1 point to compare to the design, sometimes 3, sometimes 4 nearest and sometime 8. What I'm looking for is formula we could use to find nearest point/points in 3D, which means use a lot of SQRT(SQRT(dX^2+dY^2)^2+dZ^2)) etc. In return I'd like to see Id of the nearest point, the rest I'll figure with VLOOKUP etc., is there any chance to define how many nearest points we need to get ?

    Please advice.
    P.S. (I'm new over here, sorry if we already had similar issue in the past, couldn't find by myself

    See attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Nearest coordinates 3d distance - surveyor

    Please Login or Register  to view this content.
    2nd smallest = replace red "1" by 2

    is there any chance to define how many nearest points we need to get ?
    I don't know how many you need.

    EDIT : I also added the sqrt and the 2nd + 3rd nearest point
    Attached Files Attached Files
    Last edited by bsalv; 11-12-2021 at 10:24 AM.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Nearest coordinates 3d distance - surveyor

    Hi piosta,

    I'd do this problem using all points in table A and B and then a conditional formatting to show the lowest 5 values. See if this works for you.
    Closest Points in Space.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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 distance from Lat/Long GPS Coordinates
    By lukedef90 in forum Excel General
    Replies: 3
    Last Post: 06-19-2017, 01:52 PM
  2. How to calculate distance between coordinates
    By madelingirly in forum Excel General
    Replies: 4
    Last Post: 10-01-2015, 02:00 PM
  3. [SOLVED] geo-coordinates distance issue
    By dmitrij in forum Excel General
    Replies: 1
    Last Post: 02-20-2014, 09:58 AM
  4. Distance between Coordinates
    By dustinh48625 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-11-2013, 09:17 PM
  5. Replies: 7
    Last Post: 07-29-2013, 04:51 PM
  6. Coordinates and Distance formula
    By cporter5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2010, 06:41 PM
  7. [SOLVED] Distance between two sets of coordinates.
    By Marcus Fox in forum Excel General
    Replies: 2
    Last Post: 03-20-2006, 12:40 AM

Tags for this Thread

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