VBA routine to compare 2 datasets and remove points closer than 30m.

Your column that calculates distance is only calculating to the corresponding x and y in the next column, it is not comparing to ALL the other X,Y data in the orange dataset column.

To compare against ALL the other data you'll need to use this formula instead entered as an array formula (Control + shift + enter).

Please Login or Register  to view this content.

Use the whole formula to determine which data points are further than 30m (they will be indicated by a *) or use the red part of the formila only to determine the closest distance.

I ran your data though and there aren't that many that fall within 30m, most are greater than 30m except for the first point (your origin at 0,0).

If this calculation is the way you want it to work you'll need to fix that part first (or build that into the Macro).

Happy to assist if this has to be macro driven but needed to clarify the method for calculation first.