Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to set up about 4 sort levels, i.e.
first sort: no to yes 2nd sort: alpha name 3rd sort: alpha broker 4th sort: type of account All sorts are alpha |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Highlight the data to be sorted (including header row if you have
one), then sort the lower orders first - for example alpha name, alpha broker and type of account. With the data still highlighted, click on Data | Sort again and this time sort on the remaining higher level criteria (in this case no to yes). Hope this helps. Pete On May 22, 6:09*pm, worker bee <worker wrote: I am trying to set up about 4 sort levels, i.e. first sort: no to yes 2nd sort: alpha name 3rd sort: alpha broker 4th sort: type of account All sorts are alpha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |