sort range

[riniheijnen]

I have a range of 10 columns and 10 rows.

row 1 adam
row 2 benny
row 3 alex
row 4 ann
row 5 chris
row 6 duncan
row 7 arlene
row 8 ed
row 9 ashley
row 10 nick

I would like to sort the rang as follows:

row 1 adam
row 2 alex
row 3 ann
row 4 arlene
row 5 ashley
row 6 benny
row 7 chris
row 8 duncan
row 9 ed
row 10 nick

Does anyone heve a clue to have this done because I have been trying but did't succeed yet in finding the correct code.

Regards

Rini

[Bob Phillips]

How does that differ from a standard sort?

[riniheijnen]

Good morning XLD

I'll give you the real range so you will see what I mean:

WedstrijddatumAanvangstijdThuis teamUit team8-9-20128:30Zuidland E3Vierpolders E18-9-20129:00Vierpolders F1GHellevoetsluis F29-9-20129:30TOGB 13Vierpolders 38-9-201211:00Vierpolders E2Hellevoetsluis E38-9-201211:00Spijkenisse E15Vierpolders E39-9-201212:00Blijdorp 3Vierpolders 28-9-201212:30SJO PFC-Bernisse D3Vierpolders D18-9-201213:00Vierpolders B1Hellevoetsluis B18-9-201213:00Vierpolders C1WFB C38-9-201213:00Nieuwenhoorn MP1Vierpolders MP19-9-201214:30Vierpolders 1FIOS 18-9-201214:30Leonidas VR2Vierpolders VR1

I am looking for a way to sort the range bij wedstrijddatum first but that isn't so difficult. Next I want the range to begin with all rows containing "Vierpolders" in the column thuisteam and sorted on aanvangstijd. At last I want all other lines from the original range underneath sorted bij aanvangstijd again. Do you have a suggestion on how to do this.

Regards