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?
.