lat/long

  1. M

    Extract informations if distance (lat,long) between two lists of places is lower than 50km

    Hello, I have two lists of places (in two Excel sheets) : cities and swimming pools. I have the lat and long of all the places (for the cities it's the center). I want to extract a list of all the pools nearby every cities. So I would have a final list like this : - Name of the city / CityLat...
  2. E

    Shortest distance between Lat/Longs with condition

    Hi all, This has been bothering me for the last few days. What I am looking to do is find the shortest distance in miles between two lat long points, (which I have figured out thanks to posts on this site). However, I also want to limit the result to just the nearest lat long point associated...
  3. C

    deleting a number BEFORE the decimal

    Hey all, I am trying to format my lat and longs in order for Fusion Tables to be able to geocode them. I have it down to where I have separated the lat and longs into their own column. I started with this >Point><coordinates>-77.056124,35.552686,0.0</coordinates></Point> my long issues are...
  4. S

    UNSOLVABLE! Find A New Lat Long Given Current Lat Long, Altitude, Bearing, Distance, and Depression Angle

    If the title didn't say enough, here's the deal. What I have, My current aircraft altitude 400ft the current bearing of the aircraft to target is338 degrees... 5.899212872 in radians the current depression angle 15 degrees.... .261799388 in radians the current aircraft Latitude 34º 36‘...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top