G
grime
I have a column with a list of stores.
On another sheet, I have a master list of stores, with thei
corresponding latitudes and longitudes.
Given 2 stores, I have a formula that computes the distance betwee
them using each location's latitude and longitude.
I need an array that will find the maximum distance in the list o
given stores.
For example, I input 10 stores. The array would look up the location
(lat & long) of each one of the 10 stores, find the distance for eac
one to each of the other 9 locations in the list, and find the maximu
distance from the 100 possible scenarios (the 10 x 10 matrix).
The formula for computing distance is:
=(ACOS((COS((lat1/180)*PI())*COS((lat2/180)*PI())*COS(((long2-long1)/180)*PI()))+(SIN((lat1/180)*PI())*SIN((lat2/180)*PI()))))*3963.19
It would be nice to know which of the 2 locations provide the maximu
distance as well, but thats a minor issue compared to the ma
distance.
Thanks in advance for any assitance you can give..
On another sheet, I have a master list of stores, with thei
corresponding latitudes and longitudes.
Given 2 stores, I have a formula that computes the distance betwee
them using each location's latitude and longitude.
I need an array that will find the maximum distance in the list o
given stores.
For example, I input 10 stores. The array would look up the location
(lat & long) of each one of the 10 stores, find the distance for eac
one to each of the other 9 locations in the list, and find the maximu
distance from the 100 possible scenarios (the 10 x 10 matrix).
The formula for computing distance is:
=(ACOS((COS((lat1/180)*PI())*COS((lat2/180)*PI())*COS(((long2-long1)/180)*PI()))+(SIN((lat1/180)*PI())*SIN((lat2/180)*PI()))))*3963.19
It would be nice to know which of the 2 locations provide the maximu
distance as well, but thats a minor issue compared to the ma
distance.
Thanks in advance for any assitance you can give..