Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 9 column headers: Column 1 = Code, Column B = Date, Colum C = Name,
etc. Below Column B dates and sub-headings. After I sort, Col 1 = Ascending, Column B = Ascending and Col. C = Ascending. The Problem is, on Col B, the dates are sorted ascensing but the sub-header (lets say APPLICANTS) will be on the last row (where the last Code 1 on col A). I used Descending to sort Col B. The sub-header stays on top BUT THE DATES are of course arranged descending. Is there a way to sort Col B so the sub-header will be on top and at the same time, the dates will be sorted Ascending? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |