Sorting by Sections Problem
Dear all,
I've data in column A and are separated by sections. Each section has a
heading. For example:
ELS Team:
Peter
Ken
Justin
PLP Team
Paul
Mary
Byran
May
QWS Team
Wilson
Tim
Isa
If sometimes later, the name "QWS Team" is changed to "DGK Team" and I want
to sort the teams again in alphabetical order of team name so that "DGK Team"
is in front of "ELS Team". Please advise how can I sort the data by section
name like the example above.
Thanks in advance.
|