Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 8th February 2009, 11:11 AM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 724
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
  #2  
Old 8th February 2009, 11:24 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,287
Default

Highlight both columns of information then go to data at the top and select sort, a selection box will open in the top box you select the column with the information you want to sort by and then selec decending, in your case the column with the ratings, then click ok it will sort it for you.
Reply With Quote
  #3  
Old 8th February 2009, 12:48 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 724
Default

Hi Shaun,

I have tried that, but it does'nt sort both columns, just the TAB# column, so I end up with the highest rated at the top, but the horses rating score stays in the same spot. Any other suggestions? Thanks for your help so far.
Reply With Quote
  #4  
Old 8th February 2009, 01:04 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 392
Default

Highlight the cells in column B go to sort & filter, sort largest to smallest.
Reply With Quote
  #5  
Old 8th February 2009, 01:19 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 724
Default

Hmm, it seems that because column b is a formula that adds up the total ratings for each horse, the column itself cant be sorted. So is there a way to take the data from column b, copy it into another column without the formulas attached, so there is nothing stopping it from being sorted?
Reply With Quote
  #6  
Old 8th February 2009, 02:53 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 392
Default

Quote:
Originally Posted by thorns
Hmm, it seems that because column b is a formula that adds up the total ratings for each horse, the column itself cant be sorted. So is there a way to take the data from column b, copy it into another column without the formulas attached, so there is nothing stopping it from being sorted?
To copy the number into another cell eg. in cell C1 you put =B1 and drag it down the column, this will copy the number only.
Reply With Quote
  #7  
Old 8th February 2009, 03:09 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 724
Default

I've tried that, but as soon as there is a = sign in a cell, it doesn't allow sorting of the data. I am using Open Office, so perhaps it could be a difference in the software. It is no big deal I guess ultimately, I can do it pretty easily manually, just would be nice to have it fully automated.
Reply With Quote
  #8  
Old 8th February 2009, 07:02 PM
stugots stugots is offline
Banned
 
Join Date: Jan 1970
Posts: 1,131
Default

probably the simplest way would be to 'copy-paste special-values'

this removes any formulas & then you can sort as required
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 05:51 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655