Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? ;) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
find multiple occurances of a value and match to values in another | Excel Discussion (Misc queries) | |||
Finding Closest Match | Excel Worksheet Functions | |||
How to find MATCH numbers ? | Excel Worksheet Functions | |||
Using MATCH() for an exclusive find? | Excel Worksheet Functions |