How do you sort a list with more than three sort keys?
First sort on least significant key(s)
Then sort on most significant keys
HTH
--
AP
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
Excel - Sorting
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
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Data Sorting Excel Is there any formula for data sorting? Because sorting a range of data change the sequence of the original data . If there is a formula for sorting the result of sorting could be seen on different range of cells without disturbing the original data. Excel Worksheet www.contextures.com / xlSort01.html If this post helps click Yes - -- -- -- -- -- -- -- Jacob Skaria keywords: Data, Sorting description: Is there any formula for data sorting Because sorting a range of data change the sequence of the original data . If there is a
How to let the formatting follow data during sorting? Excel Hi, During sorting in Excel (primarily programmatically I am working with, but same when manually doing this), I follow the data cells. E.g., some particular cells are marked with yellow color before sorting. After sorting (e.g., entire rows), the yellow color are not moved with those particular cells, so the wrong cells get the yellow color after sorting. Any suggestions? Excel Programming Discussions Excel (1) Macro (1) HiAre (1) Shasur (1) B32AA495BECE (1 the range (usedrange or some specific range) and Excel Ignores the rest of columns during sorting Cheers Shasur - - http: / / vbadud.blogspot.com Thanks! My bad, it was Range and not entire cells. Also borders do not sort with cells. - - Jim Cone Portland, Oregon USA Hi, During sorting in Excel (primarily programmatically I am working with, but same when manually doing this), I follow the data cells. E.g., some particular cells are marked with yellow color before sorting. After sorting (e.g., entire rows), the yellow color are not moved with those particular
Sorting VLookup vs Sorting SumProduct Excel How come I can sort a table with multiple columns of vlookup and others may not have done - why not include the more detailed description here?) Are you sorting the "Discounted" sheet? I'm a little confused, even after your fuller explanation in the other post. Pete keywords: Sorting, VLookup, vs, Sorting, SumProduct description: How come I can sort a table with multiple columns of vlookup and
cell formulas issue in sorting data Excel Is it possible to keep the cell's orginal formulas after it's been sorted? E.g. if before sorting D3 = "D1", after sorting, D3 becomes to position of It sounds weird, right? Many thanks in advance, please. Grace in the first post. Please let me try again. The following chart is before the sorting: Column A data are all manually key in, Row 1 data are all manually key 10 30 2 a 20 20 3 b 10 10 4 c 30 30 After sorting the chart by "Sub-total", it becomes as below: A B C D E 1 you could see all cells between C2:E4, as long as they are moved by sorting, the original formulars were changed. . . . . . Would you please let me know if it is possible b 10 10 a 20 20 c 30 30 How exactly did you do the sorting? The range selection before you sort is all important - - Max Singapore http: / / savefile.com / projects 500 Files:362 Subscribers:62 xdemechanik - -- I did select the range before I do the sorting, and I just tried to the way you mentioned below, and it still did not
Sorting Values Without Sorting Formulas Excel Is there a way to sort values from several rows that were calculated t), if this answer was helpful. Thank you very much. This was very helpful. keywords: Sorting, Values, Without, Sorting, Formulas description: Is there a way to sort values from several rows that were calculated