Nice one Max.
--
Jim Cone
San Francisco, USA


"Max"
wrote in message
Perhaps one way. Try this play ..
(source data must start in row2 down)

Assuming source data as posted is within A2:A17
(range is inclusive of the blank row below the last section)

Put in B2: =IF(ISNUMBER(SEARCH("Team",A2)),LEFT(A2),LEFT(B1))
Copy B2 down to B17 (include the blank cell below the last section)
[Leave B1 empty]

Now, try sorting the "sections" in col A by the helper col B
Select A2:B17, click Data Sort
Check "No header row" Sort by column B (ascending) OK

Test out the sorting with various changes to the team names
Seems to work ok here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik