I am looking for a formula or set of formulas that can look at a list of store location addresses (i.e. longitudes and latitudes) and determine which stores (if any) are within a X mile radius of one another.
Does anyone know of an excel function that will allow me to quickly cluster this data based on proximity (i.e. radius)?
Hi sccrbrg,
Maybe try the function mentioned here: http://excel.tips.net/T003275_Calcul...en_Points.html
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks