lat

This may not be possible, but I have many lists of long lat coordinates. I need to weed out duplicates, but the duplicates do not have exactly the same long lat coordinates, but they are close..... say within 30 feet. Everything is in decimal degrees. I need a way to calculate an entire list so...

Hi All I was looking for some help please on a Loop i need to do, I'm quite a novice when it comes to VBA and need to learn more use for it for work. I have built a tool that will show me the closest locations of certain store depending the lat and long, only problem is I can only put 1...

Good day! I am creating a Shared Workbook and need to create a dynamic table based off of the CurUser (defined name). Want to know if this is possible. Table1 (Dynamic) <TBODY> ID # Correspondence Name Submitted By Submitted On Due Date Last Action Taken (LAT) LAT By...

Hello Every one , First Thanks in advance if you solve my query . I am having a data base of 100+ lat long(Main data) , Now I am having other database which contain 20,000 + Lat Long(reference database) . I want to calculate one of each lat long of my Main data with each and every lat long of...

Hi Everyone, Not sure if this is possible but I have a list of propertys I downloadd every day. there location is show in Longatude and latatude. I want to know how many are within a 5 mile radius of my Home. also in in Longitude and latitude. So the ideal solution would be two formulas. 1...

Here is a Website Link http://www.rcn.montana.edu/resources/converter.aspx Option Explicit Sub UTM_Converter() ' Place all your declarations here Dim i As Long Dim browobject As Object Dim obj1 As Object Dim obj2 As Object Set browobject =...

I need "Last used column" in code. Example, last column used is AI, so AI column number in i variable

Have adapted an array formula from a previous thread - "Need to compare Latitude & Longitude coordinates to find closest office" The formula is in C2 and picks up Lon and Lat from A1 & A2 and locates nearest from H2:J7...

Consider this two point on the map: <tbody> latitude longitude 45.61782 9.41737 45.48568 9.20181 </tbody> The distance between each other is about 22km. What's the formula to calculate that? I tried different formulas found online but every one returned absurd values...

Hi! I would like some help where when a user types in the lat and long and clicks on a button, I would like the coordinates to show up in the google maps. Any help will be appreciated! Thank you very much :)

Hello, I have two tables. Both have Lat and Lon values in them along with other data. For each row in table A I need to find the index of table B where the Lat and Lon is the closest. I have a formula for working out the distance but I don't know how to incorperate it into a match type...

I have a huge spreadsheet of locations with lat and log. I need to calculate the distance between all locations from each other within a specific state, as well as finding the locations closest to each other. I have the basic formula for calculating distance between point A and point B. Is...

Hi, i have a list of coordinates (lat/LON decimal format wgs84) and i would like to find the extremity or perimeter points, i.e. to find the point that will define a polygon ignoring the inner points. Yossi

Hey guys and gals, here is a good one, Given 3 latitudes and longitudes, can you calculate the bearing from the first lat/long to the second lat/long. 2nd to 3rd, then 3rd to first? The ULTIMATE goal is to create an irregular polygon given multiple lat longs, and determine the area. I don't...