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
Bookmarks