New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

find the nearest neighbor in the data set

Macros, VBA, Excel Automation, etc.

find the nearest neighbor in the data set

Postby robert012345 » Mon Jan 04, 2016 8:34 pm

Hi Everyone,
First of all,
Happy New Year 2016
Wish all of us have a great year 2016
I have a set of data , usually is about 25000 data points with X,Y coor,
I need to find the nearest neighbor data point , measure the distance and put it into another column,
Hope the attached is clear enough,(I need to find and fill in all yellow cells)
Truly appreciate all your help in this great forum,

Thanks again and best regards,
Robert
  • 0

You do not have the required permissions to view the files attached to this post.
robert012345
Rookie
 
Posts: 8
Joined: Aug 15, 2015
Reputation: 0
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 162 guests