Nearest point

[AmirTaj]

So, I have 3 sets of 50 point with x and y coordinate. Each set start from origin (0,0). What I must do is arrange all the points so that 1st point and 2nd point is nearest compared to 3rd,4th and 5th point. After locating 2nd point, I must then find the nearest point to the 2nd point. And so on.

All this 3 sets have different x and y location.

So far I'm using sqrt to make a table and sort thing out. But it is difficult to choose the nearest point with so many numbers on the table. Then I added conditional formatting to highlight smallest value. It seem so clustered and confusing.

So my question is, how to locate nearest point using excel.



p/s- newbie here. please be gentle guys =)

 

[AmirTaj]

sorry. my bad.

what I meant by wrong is it did not go to the nearest point from the starting point. the sequence look like a jumbled up sequence.

 

[offthelip]

What I must do is arrange all the points so that 1st point and 2nd point is nearest compared to 3rd,4th and 5th point. After locating 2nd point, I must then find the nearest point to the 2nd point. And so on.

You need to be a lot more specific about what you original requirement is, because what I programmed was my best guess as to what you wanted. I now have no idea what you want.