the problem I think is probably very simple, but I am stuck,
I have a list of coordinates with their ID numebrs and would like to cluster the points that are at a distance less than 20 to each other.
To start with, I sort the data by the X then the Y column so that the points that would cluster would already be grouped together. On a separate column, I calculate the distances. From these I would like to then group the values by a letter name. From that I can then set up a table with the number of encounters for each group, together with the average values for each group.
I have to do that for several hundreds of sheets, and get the table with the averages for each one.
I have enclosed a spreadsheet as it is easier to follow I think!
Many thanks for any help!