View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default 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.