@wicksta
Do you think you could post your final product? I'm looking at pulling from a simple table from a live html and it looks to be easier than what you were trying to do. Thanks!
Hello,
See attached for what I've started. As you can see cell I3 is the result of the site that is closest to the Lat and Lon placed in B3 and C3. Sites are already preloaded so that as the tool is used different coordinates will be entered to find the closest site. Column P will only show a...
Hello,
I have a column with cells containing the same concatenate formula. I've set a condition with these formulas where concatenate will not occur unless "Best" shows in the column to the left.
I want to be able to display the only concatenate result (which could appear in any of the 300...
Thanks all for the help!!
@Nebu You're formula was the bulk of it. I cleaned up the rest of the STDEV to get rid of the divide by zero error caused by repeats in lats/longs. Course calculations show "" while STDEV displays "N/A".
Hello all,
I've been doing some research and cannot find any info in this area. Here's the bottom line:
Using different tracks of geographical data (decimal degree format) it is possible to calculate the course heading or azimuth of these various tracks...