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
> How would you sort the following matching absolute values to look like it
> does in the "After" view?
[quoted text clipped - 16 lines]
>
> Thanks, Chris
Chris - 31 Jan 2008 20:59 GMT
Fantastic Mike - thanks for the help,
Chris
> Chris,
>
[quoted text clipped - 28 lines]
> >
> > Thanks, Chris