G
Guest
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?
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?