Sorting Negative with Positive Values
Fantastic Mike - thanks for the help,
Chris
"Mike H" wrote:
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" wrote:
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
|