I have the user enter up to 20 locations, to which are associated
coordinates.

I would like Excel to be able to identify groups of locations based on
their proximity to each other.

So if 5 of those "locations" are within a certain distance from one
another, Excel would assign a group number to those 5, and so on with
all 20 locations.

Can anyone point me into the right direction? Is this problem too
difficult for wittle ol' Excel?


--
grime
------------------------------------------------------------------------
grime's Profile: http://www.excelforum.com/member.php...o&userid=19227
View this thread: http://www.excelforum.com/showthread...hreadid=477182