Is it possible to have more than 3 sort criteria?

[ThomJeff]

Or is this a limit of Mac 2004 Excel?

I'd love to have 10, but would be very happy
with 5. Is it possible?

TIA,

Thom

 

[Bob Greenblatt]

No. However, Just sort the file on the least significant 3 criteria, then
sort it again on the next 3 etc.

 

[Jean-Claude Arbaut]

Le 17/06/2005 14:01, dans BED833CC.43B34%[email protected], « Bob Greenblatt »

No. However, Just sort the file on the least significant 3 criteria, then
sort it again on the next 3 etc.

Is there a guarantee that Excel sort algo is "order-preserving" ?

 

[ThomJeff]

No. However, Just sort the file on the least significant 3 criteria, then
sort it again on the next 3 etc.

Thanks for the suggestion. I was afraid the
limit was 3.

Thom

 

[JE McGimpsey]

Le 17/06/2005 14:01, dans BED833CC.43B34%[email protected], « Bob Greenblatt »


Is there a guarantee that Excel sort algo is "order-preserving" ?

Not positive what you mean by "order preserving", as sorts by their very
nature change the order, but if you mean "will Bob's solution work?",
the answer is "yes".

 

[Corentin Cras-Méneur]

Is there a guarantee that Excel sort algo is "order-preserving" ?

As far as I can tell, that's indeed how it works.

Corentin

 

[Jean-Claude Arbaut]

Le 18/06/2005 01:20, dans
(e-mail address removed), « JE McGimpsey »

Not positive what you mean by "order preserving", as sorts by their very
nature change the order, but if you mean "will Bob's solution work?",
the answer is "yes".

Take a n x 2 matrix

5 7
4 8
4 5
4 3
3 6
4 4
1 2

That's just an example... If you sort according to 1st column,
and sort is "order-preserving" (maybe the term is incorrect),
then the 2nd column will still have "8, 5, 3, 4" in that order.
I mean, if several rows have same 1st column value, then
relative positions of 2nd column don't change (their order
is preserved). Not all sort algorithms do that. And bob's method
will work only if this property is true.

 

[JE McGimpsey]

And bob's method will work only if this property is true.

It will work.

 

[Jean-Claude Arbaut]

Le 18/06/2005 05:59, dans
(e-mail address removed), « JE McGimpsey »

It will work.

Ok, thanks

 

[Bob Greenblatt]

Yes.

Le 17/06/2005 14:01, dans BED833CC.43B34%[email protected], « Bob Greenblatt »


Is there a guarantee that Excel sort algo is "order-preserving" ?