F
Fran
How do you sort a list with more than three sort keys?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ardus Petus
First sort on least significant key(s)
Then sort on most significant keys
HTH
Then sort on most significant keys
HTH
B
Bill Ridgeway
You need a helper column. In this should be a formula concatenating all the
fields to be sorted.
=A1&B1&C1 ...
This will sort only in ascending order. You will need to include the value
of dates (not the actual dates) -
&VALUE(A1) or &VALUE("01/04/2006") as applicable
Regards.
Bill Ridgeway
Computer Solutions
fields to be sorted.
=A1&B1&C1 ...
This will sort only in ascending order. You will need to include the value
of dates (not the actual dates) -
&VALUE(A1) or &VALUE("01/04/2006") as applicable
Regards.
Bill Ridgeway
Computer Solutions
B
Bill Ridgeway
I've had a re-think on this.
You need a helper column. In this should be a formula concatenating all the
fields to be sorted.
=A1&B1&C1 ...
This will sort the whole in ascending or descending order only. You will
need to include the value of dates (not the actual dates) -
&VALUE(A1) or &VALUE("01/04/2006") as applicable
If you need to sort in descending order you will have to use a separate sort
key.
Regards.
Bill Ridgeway
Computer Solutions
You need a helper column. In this should be a formula concatenating all the
fields to be sorted.
=A1&B1&C1 ...
This will sort the whole in ascending or descending order only. You will
need to include the value of dates (not the actual dates) -
&VALUE(A1) or &VALUE("01/04/2006") as applicable
If you need to sort in descending order you will have to use a separate sort
key.
Regards.
Bill Ridgeway
Computer Solutions
D
David McRitchie
The other solution is the more correct solution. Your solution
with concatenation is really only valid if each part in the concatenation
has a consistent length. Consider the following list. Correctly in sequence.
AA B
AA BC
AAA B
Sorting the concatenation could produce incorrect results as in:
AAAB
AAB
AABC
with concatenation is really only valid if each part in the concatenation
has a consistent length. Consider the following list. Correctly in sequence.
AA B
AA BC
AAA B
Sorting the concatenation could produce incorrect results as in:
AAAB
AAB
AABC