Forum Discussion
Finding clusters of points on a map
I have a long list of latitudes and longitudes constituting a list of points on a map. My goal is to identify, for each point, how many other points in the list are within 2 miles, and return the res...
Let me illustrate on very simple sample.
In column C we have some point and in D calculate for each point how many other point have value which differ from this one on not more than one. Formula could be
=SUMPRODUCT(--(ABS(C3-$C$3:$C$9)<=1))-1and drag it down.
Perhaps similar works in your case, but it's better to play with actual data.