Quote:
Originally Posted by Steve81uk
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
02-02-2015, 08:46 AM
Similar Threads
Bad view when using Find and Find & Replace - Word places found string on top line
Windows 7 64bit 
Office 2010 64bit
Threaded Mode