#1
|
|||
|
|||
find a way to show a closest to using lat and long cordinates
Tried a few ways at doing this but need help, using Lat and Long coordinates I would like to find the closest (lets just call for example) "well"
I have attached a sheet, the first tab needs to show the closest beside each location. This shows two separate columns, one Lat and the other Long, then using the "well" tab, I would like to find the closest one to each Location. Am sure there must be a way, I just cant get my head around it, have tried doing matches, Chooses, Lookup functions but not having much luck. Any help would be greatly appreciated. I have been advised to try the excel programming page from the other. Thanks very much |
#2
|
|||
|
|||
HI,
A suggestion. Get rid of the dup's in the sheet "Location". Then you may be able to use lookup. I have not tried. But...... |
#3
|
|||
|
|||
HI,
Sorry for the quick post. But, even if you delete the dup's the "Lookup" will not work. Just checked... |
#4
|
|||
|
|||
Bugger it, thanks for your quick response, I wasn't sure if this was possible, just going to have to do this the good old fashioned way with maps and a ruler app.
Thanks very much anyway Cheers Steve |
#5
|
||||
|
||||
See my reply to your separate thread: https://www.msofficeforums.com/excel...t-newpost.html
There's no programming required for this one.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
trying to find a way to show a closest to using lat and long coordinates | Steve81uk | Excel | 22 | 01-28-2022 12:48 PM |
Show two alternating slides as long as music plays | Magic | PowerPoint | 2 | 11-23-2014 09:02 AM |
Highlight and put bookmark on the closest field to the cursor | b0x4it | Word VBA | 11 | 05-19-2011 11:15 PM |
Question: Hyperlink to other show, but close the current show | habibfikri | PowerPoint | 0 | 12-26-2010 02:37 AM |
PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin | VictorS | PowerPoint | 0 | 10-16-2010 10:23 AM |