coordinates

  1. D

    Complex Distance Formula

    Hi, I am trying to find the nearest distance between many points. I have a set of about 300 coordinates that I am comparing to a list of about 4k coordinates. I am using the formula...
  2. M

    Formula to search for most previous match?

    I'm setting up a spreadsheet to display monitoring data in the form of X, Y and Z coordinates. I want to be able to show the relative and cumulative differences between measurements. The formula for the relative difference is just comparing it to the cell above, whilst the cumulative is...
  3. V

    VBA: Find coordinates of markers on chart and attach a textbox to them

    Hello, I have a 2 data series. The 2nd data series only consists of points that I want shown on the first data series. So I have a price and date series with markers showing up only on specific dates. I would like to attach text boxes, or place text boxes, near those markers. I figured one way...
  4. S

    Help with determining near duplicates in long list of longitude latiude coordinates

    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...
  5. A

    Enter numbers and x, y axis

    Would you please be so kind as to show me how to create a formula in Cell F3 after entering any (x,y) coordinates from range B2:D4 and then it will automatically display the corresponding number in Cell F4? Also, vice versa, how to create a formula in Cell F7 and enter any numbers from...
  6. C

    extract multiple values from text string

    Hi, Can you please help me pull out certain values from a text string? I would like to use a formula and not code. The string is very long and is a series of coordinates and is in cell A3 and is in the format below...
  7. C

    Coordinates from text & rotate

    Hi, I have a series of .csv files that contain 2d x&y coordinates like so {x:416.83624,y:379.13855,status:0},{x:415.50653,y:378.78394,status:2},{x:414.4428,y:379.13855,status:2},... There are thousands of these points, all in text in one cell. How can I pull out the x & y coordinates and drop...
  8. T

    Separate GPS Coordinates

    <tbody> Coordinates Latitude Longitude 3.321151, 101.575798 Formula to Seek Only Before Comma Formula to Seek only After Comma </tbody> Possible ?
  9. C

    Sum data based on coordinates

    <tbody> a b c d 1 5 2 7 100 2 10 4 14 200 3 15 6 21 300 4 2 8 28 400 </tbody> If I have a table like the one above with column and row headers...NB. these are not the Excel headings, they are specific to the table and could appear anywhere on a worksheet. I...
  10. r1998

    Line Chart Problem

    Dear Friends and Respected Seniors, I have the Y coordinates for a simple line chart from A1 to A8, I select A1-A8 and create a line chart (X coordinates are generated automatically from 1-8) Data in A1 to A8 is <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 1 2...
  11. 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...
  12. M

    Help - export range with vba to txt file

    Hi to all, I have an excel file and I want to export the contents of text cells (range C2:D5) ... in a file.gcp (is a text file)....maybe someone has a VBA code ... to export values from range C2:D5 like this: MYTEXT A-z,1.00,2.00,MYTEXT Z-a (where 1.00=C2 and 2.00=D2) MYTEXT...
  13. D

    Calculate new coordinate with distance

    In my mind this is simple - it is probably an excel nightmare: My company has a geographical map that needs thousands of coordinates pinned so it can be accessed through a map app. The coordinates are close - so I want to pin one coordinate and calculate the next by adding a few feet in...
  14. D

    Seeing 2 coordinates for a Cell. Never seen before

    Got a file from another company. It is showing two coordinates for each cell. It has numbers across the top rather than letters. Has anyone ever seen this before? Is there any way to convert to normal Excel?
  15. northwolves

    Coordinates of two endpoints of a line segment

    Any one knows how to use VBA to get the coordinates of two endpoints of a line segment in a worksheet? Million thanks.
  16. A

    Coordinates for Drawing Lines in Excel Using VBA

    Hi, I have been trying to set a grid of 50 cells x 50 cells and use the Shapes.Addline method to draw lines on it using coordinates that relate to that grid. I think I understand the coding but am not clear how Excel decides where to draw the line on my screen. For example if I use...
  17. A

    Mouse Movement Through VBA

    Hi Team, I have an requirement where i need to move the mouse cursor to to particular element on the screen. I tried to look the code but only able to find the code by setcursorposition where in you need to have the coordinates. Is there any possibility that we can move mouse cursor without...
  18. M

    setting the cursor position in a vba form

    If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...
  19. N

    How to Position A Userform At A Certain Point

    Facing problem with positioning User Form on screen as it goes to the left top Corner. I want it in center or as per my coordinates?
  20. P

    Extract vectors from multiple dynamic matrices

    Hello everyone. The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for: Rows Per Group Columns per Group Starting X-Coordinate Starting Y-Coordinate Starting Z-Coordinate Rectangle Width Rectangle Height...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top