1. S

    Formatting Dotted Decimal Values

    Hello Experts, I have single column showing decimal latitude and longitude of some points and they are separated by commas. This column has multiple no of rows but the no of digits after the decimal for each entry is not static. I would like to have code that will read the latitude and...
  2. D

    Can you get the county for latitude and longitude with a macro

    I have Latitude in cell I3 and Longitude in cell J3 in decimal degrees like this 34.40561111 -83.21211111 is there a way to get the county from the coordinates and put it in cell K3? In this case it would be Franklin. This will be for coordinates in the US only if that makes any difference and...
  3. muhammad susanto

    Custom Format For Typing Latitude & Longitude GPS

    hi all.. how to creating Custom Format to typing Latitude & Longitude like this : case 1 (Latitude) <tbody> data desired result 1679755 1.679755 18632547 1.8632547 </tbody> case 2 (Longitude) <tbody> data desired result 101429118 101.429118 101419375 101.419375...
  4. R

    Latitude/ Longitude Formatting

    Hi All - It's been a while - hope one of you can help. I have latitude & longitude information in a text string that I am trying to convert to decimal format. In cell A1 the Latitude value is 0434010N In cell B1 the Longitude value is 0792201W In both of the above; Characters 1 - 3 represent...
  5. M

    Sumif within distance from a latitude and longitude pairing

    Hi there, I have two lists of coordinates (i.e. latitudes and longitudes), the second of which has a "sales count" associated with it. I want to get a sum of the "sales counts" occurring within x miles of the first list of coordinates. How would you suggest I do this? See below: <tbody>...
  6. N

    Verifying Longitude and Latitude

    I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and...
  7. D

    Extract Latitude e Longitude strings from text

    Hello, I have a .txt file with a very long text. I would like to extract Lat and Long that follow the text "Coordinate: " using this pattern ##°##’##,##” N - ##°##’##,##” E after the comma can be one or two digit and after the dash there is often, but not always, a space character. I would...
  8. B

    Calc new Long/Lat based on centroid Long/Lat

    Hello all, I have a centroid (center pivot) with a known Longitude/Latitude. I have a distance, in feet, away from the known center point for both Latitude(X)/Longitude(Y). I need to calculate the new Latitude/Longitude for each point so that I can create a yield map. In the example below, I...
  9. H

    Calculate LAT/LON when given start LAT/LON, azimuth and distance

    I need to calculate the end LAT/LON for thousands of lines of data. The existing spreadsheet has the start LAT, start LON, azimuth and distance. Is there a formula so excel can calculate it for me?
  10. M

    Finding the closest site (Latitude / Longitude) to a long list of coordinates along a path.

    HI, let me thank you in advance for any all suggestions and solutions! I have been working on this problem for a while now and cannot find a solution. I have an extensive workbook with 3000+ sites. Each site has information specific to that site. Latitude, Longitude, Site Identifier, etc...
  11. M

    Calculation of latitude and longitude

    Hi, I need to calculate latitude and longitude for given speed and heading. First value of latitude and longitude is provide rest of the values need to be calculated for given other parameters such as speed and heading d1=speeds(1)*stept1; d2=speeds(2)*stept2...
  12. R

    Longitude and Latitude Calculations advice

    Good afternoon everyone I have used gmaps functions to fetch a list of longitude and latitudes for a (very long) list of delivery points for one of my customers. I am attempting to calculate the centre of gravity for the distribution (not to be confused with the centre of mass of a physical...
  13. P

    Eliminating Columns and Rows

    I have a spreadsheet. Latitudes are across row 1. Latitudes are across row A. The lower case letters are values of some function. I would like to delete all the columns and rows in the spreadsheet except for those that are closest to .00, .25,.50, .75. For example, this <colgroup><col><col...
  14. P

    Make Geographic maps Using Excel

    Question 1 The longitudes are across the 1st row. The latitudes are in column A. The values of my dataset are in the intersections of these. How would I create a contour map of this on the earth? <tbody> A B C 1 -80 -70 2 40 5.3 18.6 3 30 17.9 20.2 </tbody>...
  15. S

    Calculate distance and bearing, given latitude and longitude of points

    Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate: A: distance B: bearing (initial bearing along a great circle ie the shortest distance) C: bearing along rhumb lines ("constant bearing") For example if you want to go from 0, 0 to 0, 90E, the answer to C would...
  16. A

    Expert level: Proximity matching for latitude/longitude

    Hi Excel Geniuses I've got a doozy of a question. I'm trying to take a center point (lat/long) and then use that value to reference a table to find the three closest matches by lat/long proximity. Here is a simplified example: The first spreadsheet has the centering location value and we...
  17. M

    Cell Formatting to except Longitude & Latitude in DMS anD format them

    Hi, I hope this is pretty simple. I have been asked to take over address for the county i works for and I am in the process of creating an Excel (2010) template sheet that the Secretary taking the address request calls can fill out information I need to verify and add an address. I have two...
  18. J

    Latitude And Longitude Of Active Cell

    Does anyone have a vba script to list the co-ordinates (latitude and longitude) of the activecell so that I can move the cursor to that position. I have the following script which lists the cursor position, but would like the cell position co-ordinates. Dim MyPointAPI As POINTAPI Private...
  19. W

    Sorting Locations

    I have a several rows of addresses in one column followed by lat/long in the next columns. a 416 Snider Avenue SE, Olympa, WA 47.0354605 -122.9030842 b 1315 10th Street, Sacramento, CA 38.576927 -121.4949038 c 900 Court Street Northeast, Salem, Oregon 44.9390127 -123.0300577 d 700 W...
  20. J

    Macro Recorder

    Just wondering if you can use excel like a macro recorder program IN THE FOLLOWING WAY. With a macro recorder program the program clicks on specific points of i.e. latitude longitude, so if you had a textbox or userform etc... you could have a script to select a specific point anywhere on your...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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