My data consists of hundreds of latitude and longitude coordinates; example:
Excel 2010 32 bit
Desired output is the latitude and longitude coordinates for the location which is most proximate to all of the input coordinates. Is this possible w Excel?
I appreciate any help, suggestions, etc. Thanks!
Excel 2010 32 bit
B | C | |
---|---|---|
1 | Lat | Long |
2 | 34.4340498 | -119.8517606 |
3 | 34.43887174 | -119.8086146 |
4 | 34.4325943 | -119.8504486 |
5 | 34.16938019 | -118.4502411 |
6 | 34.1530838 | -118.2308807 |
7 | 34.238292 | -118.561477 |
8 | 34.27641504 | -118.8813434 |
9 | 32.8698425 | -117.2166739 |
10 | 34.419502 | -118.564674 |
11 | 32.86818221 | -117.2169603 |
12 | 34.17403412 | -118.5585022 |
13 | 34.005157 | -118.489059 |
14 | 34.19234085 | -118.5961304 |
Sheet: Sheet2 |
Desired output is the latitude and longitude coordinates for the location which is most proximate to all of the input coordinates. Is this possible w Excel?
I appreciate any help, suggestions, etc. Thanks!