View Single Post
  #1  
Old 8th February 2009, 10:11 AM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default Spreadsheet help

I am currently playing round with my own ratings and am after some help on how to sort the final ratings in the spreadsheet.

In column A I have the tab number, running up to 25 max for big fields. In column B I have the horses final rating. Is there a way to sort the two columns so that the ratings are arranged in descending order, but still keep the data in column A in the same row?

ie
A B
Tab# / Rating
1 / 1
2 / 5
3 / 4
4 / 2
5 / 3

And I want it sorted automatically to look like

TAB# / Rating
2 / 5
3 / 4
5 / 3
4 / 2
1 / 1

Hopefuly someone can enlighten me on this.

Cheers
Reply With Quote