Thread: Sorting
View Single Post
  #1   Report Post  
DAA
 
Posts: n/a
Default Sorting

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?