Multilevel Sorting?

[Mike]

Is there a way to get around the 3 level limit in sortng. Want to sort by 4
sets to 4 levels or more.

[Peo Sjoblom]

Not in one fell swoop, first sort the least significant etc
assume you would sort by columns A, B, C and D (in that order of
significance)
select C:D and sort in that order, then select A:D and sort by A

--
Regards,

Peo Sjoblom


"Mike" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to get around the 3 level limit in sortng. Want to sort by
> 4
> sets to 4 levels or more.

[JE McGimpsey]

Sort the least significant column first, then sort on the most
significant 3.

In article <[email protected]>,
"Mike" <[email protected]> wrote:

> Is there a way to get around the 3 level limit in sortng. Want to sort by 4
> sets to 4 levels or more.

[Myrna Larson]

Hi, Peo:

If the data requires 4 columns, A:D, I don't think you want to "select C:D and
sort" do you? That will uncouple the data in columns C and D from that in
columns A and B.

I think you mean to select columns A:D, sort on D (or C and D), then with A:D
still selected, sort on A, B, and C (or A and B). No?


On Mon, 18 Apr 2005 06:40:36 -0700, "Peo Sjoblom" <[email protected]> wrote:

>Not in one fell swoop, first sort the least significant etc
>assume you would sort by columns A, B, C and D (in that order of
>significance)
>select C:D and sort in that order, then select A:D and sort by A

[Peo Sjoblom]

Correct, meant select all columns and sort by the least significant first
Thanks

--


Peo Sjoblom


"Myrna Larson" <[email protected]> wrote in message
news:[email protected]...
> Hi, Peo:
>
> If the data requires 4 columns, A:D, I don't think you want to "select C:D
> and
> sort" do you? That will uncouple the data in columns C and D from that in
> columns A and B.
>
> I think you mean to select columns A:D, sort on D (or C and D), then with
> A:D
> still selected, sort on A, B, and C (or A and B). No?
>
>
> On Mon, 18 Apr 2005 06:40:36 -0700, "Peo Sjoblom" <[email protected]>
> wrote:
>
>>Not in one fell swoop, first sort the least significant etc
>>assume you would sort by columns A, B, C and D (in that order of
>>significance)
>>select C:D and sort in that order, then select A:D and sort by A
>