| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
How do I specify the most important, next most important, the next most
important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
Best to have a look at Help on Sort a range.
You have to specify the sort priority yourself. Sort by, then by, then by. Gord Dibben MS Excel MVP On Tue, 20 Oct 2009 16:46:03 -0500, "Doug Mc" wrote: How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
Always remember to experiment on a copy of the worksheet.
Gord On Tue, 20 Oct 2009 15:54:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Best to have a look at Help on Sort a range. You have to specify the sort priority yourself. Sort by, then by, then by. Gord Dibben MS Excel MVP On Tue, 20 Oct 2009 16:46:03 -0500, "Doug Mc" wrote: How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
Thanks Gord,
Do I sort the most important first or last? "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Always remember to experiment on a copy of the worksheet. Gord On Tue, 20 Oct 2009 15:54:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Best to have a look at Help on Sort a range. You have to specify the sort priority yourself. Sort by, then by, then by. Gord Dibben MS Excel MVP On Tue, 20 Oct 2009 16:46:03 -0500, "Doug Mc" wrote: How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
I guess you did not read Help on sort a range.
Sort by 4 columns Click a cell in the range you want to sort. On the Data menu, click Sort. In the first Sort by box click the column of least importance. Click OK. On the Data menu, click Sort. In the Sort by and Then by boxes, click the other 3 columns you want to sort, starting with the most important. Select any other sort options you want, and then click OK. Gord On Tue, 20 Oct 2009 18:14:29 -0500, "Doug Mc" wrote: Thanks Gord, Do I sort the most important first or last? "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Always remember to experiment on a copy of the worksheet. Gord On Tue, 20 Oct 2009 15:54:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Best to have a look at Help on Sort a range. You have to specify the sort priority yourself. Sort by, then by, then by. Gord Dibben MS Excel MVP On Tue, 20 Oct 2009 16:46:03 -0500, "Doug Mc" wrote: How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.
Thanks Gord,
Lots of things I don't know - newbie for sure! NEW SUBJECT: I have four rows at the top of the page that contain titles of the individual columns. I want these to print on each page but I can't seem to do it. Can you give me some hints here please? Thanks, Doug "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I guess you did not read Help on sort a range. Sort by 4 columns Click a cell in the range you want to sort. On the Data menu, click Sort. In the first Sort by box click the column of least importance. Click OK. On the Data menu, click Sort. In the Sort by and Then by boxes, click the other 3 columns you want to sort, starting with the most important. Select any other sort options you want, and then click OK. Gord On Tue, 20 Oct 2009 18:14:29 -0500, "Doug Mc" wrote: Thanks Gord, Do I sort the most important first or last? "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. Always remember to experiment on a copy of the worksheet. Gord On Tue, 20 Oct 2009 15:54:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Best to have a look at Help on Sort a range. You have to specify the sort priority yourself. Sort by, then by, then by. Gord Dibben MS Excel MVP On Tue, 20 Oct 2009 16:46:03 -0500, "Doug Mc" wrote: How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will stay with their key column???? Thanks, Doug |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixing primary and secondary axis | Excel Discussion (Misc queries) | |||
| primary/secondary axis next to each other | Charts and Charting in Excel | |||
| how to indicate on chart which axis (primary or secondary) in use | Charts and Charting in Excel | |||
| Primary & Secondary axes to have same value | Charts and Charting in Excel | |||
| primary & secondary axis | Charts and Charting in Excel | |||
Hybrid Mode
