Thread: [Solved] trying to find a way to show a closest to using lat and long coordinates
View Single Post
 
Old 02-02-2015, 08:46 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by Steve81uk View Post
So definitely no formulae / calculation. My coding abilities are close to non existent, so I think will just settle with having to use a map app to manually do it. just wanted to make my job at work easier.

I'll try the programming forum they may have some ideas.

Thank you for getting back to me.
I don't know. It might be possible with some array functions, but that is again above my pay grade.

I googled "lookup comparing coordinates excel" and there were a lot of articles, some going back as far as 2002. There were a few promising solutions, but they all required code e.g. http://www.excelbanter.com/showthread.php?t=121991
Reply With Quote