trying to find a way to show a closest to using lat and long coordinates

		Microsoft Office Forums > Microsoft Excel > Excel
trying to find a way to show a closest to using lat and long coordinates

FAQ

Thread Tools

Display Modes

#16

04-24-2018, 04:03 PM

macropod

Windows 7 64bit trying to find a way to show a closest to using lat and long coordinates

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Two things - you would have to change the '151' references in the formula to 766 and you must enter the formula as an array formula (Ctrl-Shift-Enter).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

find the closest, lat and long

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show two alternating slides as long as music plays	Magic	PowerPoint	2	11-23-2014 09:02 AM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
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 11:45 AM.