View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Help! Find Closest Coordinate Match

I have two arrays of (x,y) coordinates. Each with roughly 500 pairs. Call
one "Design" and the other "Actual". I need to find the distance from each
Actual coordinate to it's closest Design coordinate. Problems: 1). There is
low probability that any of the Actual coordinates with exactly match the
Design coordinates. 2). The arrays are not ordered anywhere near to
coorespondence (ie. Design coord x1,y1 will not necessarily coorespond with
Actual coord x1,y1). 3). Some Design coordinates will not have any Actual
matches.

Difficult enough? ;)