Sort worksheet on multiple keys - Primary, secondary, tirterary, etc.

[Doug Mc]

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

 

[Gord Dibben]

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

 

[Gord Dibben]

Always remember to experiment on a copy of the worksheet.


Gord

 

[Doug Mc]

Thanks Gord,
Do I sort the most important first or last?

 

[Gord Dibben]

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

 

[Doug Mc]

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]

Four rows or four columns with a title in row 1 of each column?

Page Setup>Sheet>Print Titles>Rows to repeat at top.

Enter 1:1 or 1:4 or select those rows in the refedit dialog box.


Gord

 

[Doug Mc]

Thanks again Gord,
I got it.

Doug

Four rows or four columns with a title in row 1 of each column?

Page Setup>Sheet>Print Titles>Rows to repeat at top.

Enter 1:1 or 1:4 or select those rows in the refedit dialog box.


Gord

 

[Gord Dibben]

I don't know what results you expect so can only reiterate the steps.

The help on sort a range states.

When sorting 4 columns, Data>Sort>sort by least important first which is
sort by Street Type only.

After that you sort the next three in order of importance from greatest to
least.

Data>Sort>Sort by Precinct Number then by Street Number then by Street Name.

For clearer headers you would do better to have your header names in one
cell rather than two cells then you won't get confused by Number(1) and (2)
and Name(1) and (2)

i.e. Precinct Number in one cell..........Street Number in one cell.

Maybe you have to change your most important to least important around.

I would say Street Name before Street Number.


Gord

 

[Gord Dibben]

For the future.

It is generally frowned upon in these Excel news groups to post attachments
and you will get very who will open your attachment.

I'm foolhardy so did open it.

If you want to carry on with this off-line email your workbook to me at

gorddibbATshawDOTca


Gord

 

[Doug Mc]

Thanks again Gord. Maybe I'll have better luck tomorrow.

 

[Gord Dibben]

Thanks.

Should have read "and you will get very FEW who will open your attachment."


Gord