Hi,
Problem is:
Have 2D (x.y coordinates) or 3D (x.y.z) coordinates.
These are generated randomnly.
Ideally they represent a lamina (2D) or sphere (3D) defined by a radius r (which could be varied).

As they have an area or volume in an area or space it is possible for them to overlap or touch within the coordinate system.
Has anyone seen any VBA (this is probably not easily possible in formulae) which would examine all the points and report if they were joined or overlapped in a cluster.
The idea being to identify all clusters with (1), 2,3 4, 5, 6, .....................,n members.
This is an important occupational health problem (dust (asbestos) particles etc). Also tropical (bacteria) medicine (my area - I am a medic)
Anything you have seen would be useful.
No way do I expect an off the shelf solution but anything which would inform my thinking would get this project moving in the right direction.
Many Thanks
P