Thread: [Solved] trying to find a way to show a closest to using lat and long coordinates
View Single Post
 
Old 04-24-2018, 04:11 PM
Leaffy Leaffy is offline Windows 10 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