+ Reply to Thread
Results 1 to 2 of 2

xy coordinate sorting

Hybrid View

joschij xy coordinate sorting 09-25-2014, 11:55 AM
joschij Re: xy coordinate sorting 09-25-2014, 12:45 PM
  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Boston
    MS-Off Ver
    ProfessionalPlus 2013
    Posts
    6

    xy coordinate sorting

    dear all

    i have the following sorting problem.
    column b&c; d&e, f&g and h&i define x and y coordinates of an object at a given timepoint (column a). the x&y are randomly distributed allong the row.

    now i want to sort the x&y coordinates to fit into a predefined square according to their value.

    for instance:
    cell 1 should only contain x y values located in the square defined with the coordinates ([x,y], [0,0], [150,0], [0, 150], [150, 150]).
    cell 2 - [151, 0], [300,0], [151, 150], [300, 150]
    cell 3 - [0, 151], [151, 151], [0,300], [150, 300]
    cell 4 - [151, 151], [300,151], [151,300], [300, 300]

    i attached a excel spread sheet with an example input and the desired output
    Tracking.xlsx

    thank you very much for your help!

  2. #2
    Registered User
    Join Date
    09-19-2014
    Location
    Boston
    MS-Off Ver
    ProfessionalPlus 2013
    Posts
    6

    Re: xy coordinate sorting

    something to add...

    if there is no value for a cell, ideally the function returns the value of the previous timepoint... if there are 2 values per cell, the function just picks the first one in the row.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Coordinate based calculations
    By Sparkplug90 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2013, 04:23 PM
  2. coordinate conversion
    By stewman in forum Excel General
    Replies: 1
    Last Post: 02-24-2011, 10:45 AM
  3. Coordinate Conversion
    By stewman in forum Excel General
    Replies: 3
    Last Post: 12-16-2010, 06:51 PM
  4. Coordinate Conversion Help
    By stewman in forum Excel General
    Replies: 4
    Last Post: 12-06-2010, 01:57 PM
  5. return value of X coordinate and Y coordinate?
    By sbmoller in forum Excel General
    Replies: 1
    Last Post: 09-22-2007, 06:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1