Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 04-24-2018, 04:03 PM
macropod's Avatar
macropod macropod is online now trying to find a way to show a closest to using lat and long coordinates 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: 19,891
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default


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
[MS MVP - Word]
Reply With Quote
  #17  
Old 04-24-2018, 04:11 PM
Leaffy Leaffy is offline trying to find a way to show a closest to using lat and long coordinates Windows 10 trying to find a way to show a closest to using lat and long coordinates Office 2010 64bit
Novice
 
Join Date: Apr 2018
Posts: 2
Leaffy is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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).
Forgot the CTRL-Shift for an array formula,

Thanks Macropod
Reply With Quote
Reply

Tags
find the closest, lat and long

Thread Tools
Display Modes


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
trying to find a way to show a closest to using lat and long coordinates Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
trying to find a way to show a closest to using lat and long coordinates 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


All times are GMT -7. The time now is 02:56 AM.


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