Location of optimal proximity based on latitudes and longitudes

[leebauman]

My data consists of hundreds of latitude and longitude coordinates; example:

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!

 

[StephenCrump]

This thread may be useful: http://www.mrexcel.com/forum/excel-questions/805615-minimize-weighted-average-distance.html

And in particular, shg's calculator in Post #13

 

[Macropod]

You may also find this useful: trying to find a way to show a closest to using lat and long coordinates

 

[leebauman]

Yes, the calculator in Post #13 seems the perfect fit for my query. Thank you.

Now, I'm realizing my ideal solution is a little different than what the Min Weighted Average Distance method will produce and, before I attempt to apply the calculator to my data, I wonder if it might be possible for the results to indicate Lat and Long coordinates for all locations which are no more than X miles (or, even better, X minutes of commute time) from my input locations?

I continue to appreciate your consideration and input!