Sorting Negative with Positive Values

[Chris]

How would you sort the following matching absolute values to look like it
does in the "After" view?

Before After
Record 1 6 Record 9 -2
Record 2 5 Record 6 2
Record 3 8 Record 12 -4
Record 4 4 Record 4 4
Record 5 9 Record 14 -5
Record 6 2 Record 2 5
Record 7 7 Record 11 -6
Record 8 -8 Record 1 6
Record 9 -2 Record 13 -7
Record 10 -9 Record 7 7
Record 11 -6 Record 8 -8
Record 12 -4 Record 3 8
Record 13 -7 Record 10 -9
Record 14 -5 Record 5 9


Thanks, Chris

 

[Mike H]

Chris,

I ahve assumed you have 3 columns of data A1 to C14

In a helper column (say D)type
=Abs(c1) and drag down
Select the 4 columns of data and sort by column D ascending and a secondry
sort of column B descending
delete the helper column

Mike

 

[Chris]

Fantastic Mike - thanks for the help,

Chris

Chris,

I ahve assumed you have 3 columns of data A1 to C14

In a helper column (say D)type
=Abs(c1) and drag down
Select the 4 columns of data and sort by column D ascending and a secondry
sort of column B descending
delete the helper column

Mike