Sorting Alphabetically

[mlmrob]

Hi guys, I have tried to automate this without success. I compile my own racehorse ratings. They are currently on the sheet in race time order. I would like to change the ratings into order by meeting rather than time.

So they would go from

York 1.50
Newmarket 2.00
Ascot 2.10
York 2.20
Newmarket 2.30
Ascot 2.40

to

Ascot 2.10
Ascot 2.40
Newmarket 2.00
Newmarket 2.30
York 1.50
York 2.20.

The data is across columns A-X
The title data is across three rows and looks like this

Fri 8th Jul 2011 1.50 Newmarket (July) (20 runners)
totesport.com Stakes (Heritage Handicap)
Class 2, 6f , Good, 3yo, Win: £62250

I currently put a space between each race on sheet manually.

You can view how the finished ratings look by clicking on the link below and click on Plus 2 on the sheet.

http://www.editgrid.com/user/ratings_plus/3122....August_14th_2011

Thanks for any input guys, much appreciated.

Rob

 

[mlmrob]

anyone with any thoughts? Thanks

 

[mirabeau]

Is there anything wrong with the standard Excel sort?

It seemed to work for me as you requested.

 

[mlmrob]

Standard Excel Sort doesn't sort it from in time order to in meeting order.

 

[mirabeau]

With your given example it worked for me.

Could you give another example where it doesn't work?