Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do
the 4th it changes everything in the other columns and then they are no longer correct |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
First sort on first three column then sort only on the fourth column. Do
select all the columns together... Example If you want to sort the range A1:Z1000 then select the whole range... Choose the three columns you want to sort on Sort If required, choose the range A1:Z1000 again then sort on the fourth column only. "canyonhiker" wrote: I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do the 4th it changes everything in the other columns and then they are no longer correct |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
See the answer under 'General Questions'...
Essentially sort on first three first then sort again on the fourth column. "canyonhiker" wrote: I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do the 4th it changes everything in the other columns and then they are no longer correct |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
Sort the 4th item first then go back and sort the other 3.
"canyonhiker" wrote: I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do the 4th it changes everything in the other columns and then they are no longer correct |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
Sorry for the wrong answer... It should be ...
Sort on 4th column first then on first three In fact - If you want to sort a list of more than three fields, you must sort multiple times, with three or fewer fields at a time. Also, you must sort the fields in the reverse order of their importance in the sort. "Sheeloo" wrote: First sort on first three column then sort only on the fourth column. Do select all the columns together... Example If you want to sort the range A1:Z1000 then select the whole range... Choose the three columns you want to sort on Sort If required, choose the range A1:Z1000 again then sort on the fourth column only. "canyonhiker" wrote: I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do the 4th it changes everything in the other columns and then they are no longer correct |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting 4 columns
Hi,
Here is another approach, suppose you want to short by columns A, B, C, D where A is the most important and D is the least important (meaning the 4th level), and suppose you have titles on row 1 and not data directly adjacent to the sort area that you don't want sorted. Put you cursor in any single cell of column D and click the Ascending Sort button. Then put your cursor in C and repeat. Continue, ending with column A. In other words sort once in each column working from the least important to the most important. In 2007 you can sort 64 levels deep with the Data Sort dialog box, which is one of the many improvements to the sort area. -- If this helps, please click the Yes button Cheers, Shane Devenshire "canyonhiker" wrote: I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do the 4th it changes everything in the other columns and then they are no longer correct |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Sorting columns | Excel Discussion (Misc queries) | |||
sorting more than 3 columns | Excel Discussion (Misc queries) | |||
Sorting columns | Excel Worksheet Functions | |||
Sorting Columns | Excel Worksheet Functions |