Sorting more than 3 pieces of data??

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

Wow, I've _never_ had this happen before. I have a spreadsheet that has 4
columns, 3 that are often extremely similar. It's the 4th one that has the
most variation in the data, and it's not getting sorted. I must have then
sort by the four, unfortunately. As only 3 fields come up in the data sort
option, was wondering if anything can be done?

Thanks.
 
A

Anya

First sort all data only by that column that you'd
indicate as the last (4th) field in the sort by tool. Then
sort all the data again by the first 3 columns.
 
H

Harald Staff

Hi

Sub-sorts stick. So
1) sort by criteria 3, 4
2) sort by criteria 1, 2.

HTH. Best wishes Harald
 
J

jeff

Hi,

You might check in HELP for more, but I believe if you
select your least important sort first and do the sort,
then separately arrange your other three, you'll be set.

jeff
 
S

StargateFan

First sort all data only by that column that you'd
indicate as the last (4th) field in the sort by tool. Then
sort all the data again by the first 3 columns.
Click to expand...

Thank you. I think I've grasped the idea. I'll give it a try.
 
M

mudraker

Sort On More Than 3 Columns

Excel's sort feature allows you to sort on up to three differen
columns. If you need to sort on more than three, you can sort the sam
range multiple times. This takes advantage of the fact that if tw
values are equal, Excel will keep them in their original order. Fo
this to work properly, you must sort in reverse order. For instance, i
you're sorting on five columns, first sort on columns 3,4,5, then sor
on 1,2.


Ages ago I found a macro that would sort on mant columns. but alas du
to a system crass I have lost this macr
 
S

StargateFanFromWork

mudraker > said:
Sort On More Than 3 Columns

Excel's sort feature allows you to sort on up to three different
columns. If you need to sort on more than three, you can sort the same
range multiple times. This takes advantage of the fact that if two
values are equal, Excel will keep them in their original order. For
this to work properly, you must sort in reverse order. For instance, if
you're sorting on five columns, first sort on columns 3,4,5, then sort
on 1,2.
Click to expand...

Okay, I think I'm understanding better what to do in terms of putting into
practice the theory said:
Ages ago I found a macro that would sort on mant columns. but alas due
to a system crass I have lost this macro
Click to expand...

Oh, darn! That would have been handy, eh?
 
Top