Sorting more than 3 pieces of data??

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.

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.

Hi

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

HTH. Best wishes Harald

"StargateFanFromWork" skrev i melding
...
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.

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

-----Original Message-----
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.


.

On Mon, 28 Jun 2004 13:16:54 -0700, "Anya"
wrote:

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.

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

On Mon, 28 Jun 2004 22:17:42 +0200, "Harald Staff"
wrote:

Hi

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

HTH. Best wishes Harald

Thank you. I believe it does. I'll try it.

"StargateFanFromWork" skrev i melding
...
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.

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.


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


---
Message posted from http://www.ExcelForum.com/

"mudraker " wrote in message
...
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.

Okay, I think I'm understanding better what to do in terms of putting into
practice the theory g.

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

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

---
Message posted from http://www.ExcelForum.com/