Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-02-2015, 08:33 AM
Steve81uk Steve81uk is offline find a way to show a closest to using lat and long cordinates Windows 7 64bit find a way to show a closest to using lat and long cordinates Office 2013
Novice
find a way to show a closest to using lat and long cordinates
 
Join Date: Jan 2015
Posts: 16
Steve81uk is on a distinguished road
Default 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
Attached Files
File Type: xlsx Help.xlsx (20.6 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
find a way to show a closest to using lat and long cordinates trying to find a way to show a closest to using lat and long coordinates Steve81uk Excel 23 05-17-2025 03:22 PM
Show two alternating slides as long as music plays Magic PowerPoint 2 11-23-2014 09:02 AM
find a way to show a closest to using lat and long cordinates 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft