Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Match Absolute Numbers (XP; SR2)

    I have one column of numbers (including both positive and negative). What I would like to do is pair the numbers together. Sort is obviously out of the question and I have thought about doing something with absolute numbers but the more I think about it I change direction.

    Any words of wisdom would be appreciated.

    Thanks,
    John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Match Absolute Numbers (XP; SR2)

    I don't understand what you are trying to accomplish.

    Do you want the list sorted numerically? (it seems not)
    Do you want it sorted in absolute order (10,-10,9,-9, etc) ?
    Some other way?

    Steve

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Absolute Numbers (XP; SR2)

    Steve,

    I did miss an important part. I would like it sorted in absolute order.

    Sorry for the lack of information, <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    John

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Absolute Numbers (XP; SR2)

    I found a solution while surfing the web by Chip Pearson.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Match Absolute Numbers (XP; SR2)

    In addition, if you do the temporary column bit, and sort by absolute value, then you might want to do a secondary sort on the original data to sort the same absolute by positive/negative consistenttly (eg 10,-10, 9,-9,8,-8,7,-7) instead of something like: 10,-10,-9,9,-8,8,7,-7, etc

    Steve

Posting Permissions

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