Calculate Minimum Distance Between Lat Long

[EC_08]

Hello Every one ,

First Thanks in advance if you solve my query .

I am having a data base of 100+ lat long(Main data) , Now I am having other database which contain 20,000 + Lat Long(reference database) .

I want to calculate one of each lat long of my Main data with each and every lat long of reference database and calculate minimum distance in meter .

For Example :: Compare A from my main data with b,c,d,e,f,g,h,....z of reference data and give output of minimum distance.

 

[DRSteele]

Perhaps this will help. Follow all the links through and something in one of those threads will be what you need.

https://www.mrexcel.com/forum/excel...ordinates-lat-lon.html?highlight=great+circle