If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Sorting more than 3 pieces of data??
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. |
#3
|
|||
|
|||
Sorting more than 3 pieces of data??
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. |
#4
|
|||
|
|||
Sorting more than 3 pieces of data??
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. . |
#5
|
|||
|
|||
Sorting more than 3 pieces of data??
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. |
#6
|
|||
|
|||
Sorting more than 3 pieces of data??
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. |
#7
|
|||
|
|||
Sorting more than 3 pieces of data??
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/ |
#8
|
|||
|
|||
Sorting more than 3 pieces of data??
"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/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Sorting when data is on 2 rows??? | RECW | Setting up and Configuration | 1 | October 18th, 2003 07:03 AM |