sort X-Y co-ordinates
 

Hi folks
What is the formula to sort from an array of X-Y co-ordinates, the points
which are very close, for instance,less than 0.1mm and greater than -0.1mm?

sort X-Y co-ordinates
 

Are you trying to sort one column of numbers?
Have you tried Data | Sort
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP?
best wishes

"twin peaks" wrote in message
...
Hi folks
What is the formula to sort from an array of X-Y co-ordinates, the points
which are very close, for instance,less than 0.1mm and greater
than -0.1mm?

sort X-Y co-ordinates
 

Yes Bernard
What I wanted is to search for the points which are very close and then
highlight automatically so that I can decide whether to manually delete them.




"Bernard Liengme" wrote:

Are you trying to sort one column of numbers?
Have you tried Data | Sort
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP?
best wishes

"twin peaks" wrote in message
...
Hi folks
What is the formula to sort from an array of X-Y co-ordinates, the points
which are very close, for instance,less than 0.1mm and greater
than -0.1mm?

.