# Thread: Match Absolute Numbers (XP; SR2)

1. ## 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. ## 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. ## 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. ## Re: Match Absolute Numbers (XP; SR2)

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

5. ## 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
•