 |
|
|
 |
|
|
|
|
|
#1
2nd September 2008, 08:52 AM
|
|||
|
|||
Updating rating columns after scratchings
Each Saturday I concentrate on the 5 metro meetings and I use different columns within excel with ratings from 1 up to however many horses in the race. Example like the average prizemoney order. After scratchings I find it time consuming reordering the column ratings. Is there a way to do this automatically without changing the tab order of the horses in each race. I have the five meetings on one sheet so if it could be done to all five meetings at once that would be even better.
Thanks in advance Twodogs 
|
|
#2
2nd September 2008, 09:49 AM
|
|||
|
|||
I'ld like to help, but without seeing a sample of what you got, is hard.
I don't understand why you can't just clear the contents of the scratched horse. And if it stuffs up your Formulas, then alter the Formula to begin with an IF Statement.
|
|
#3
2nd September 2008, 09:53 AM
|
|||
|
|||
|
Moeee
Clearing the contents is the easy part. There are no formulas in the sheet itself other than the one I use for scratchings but is unrelated to the rating data. What I want to do is you start of with say the average prizemoney ratings 1 through to 10 but you have 2 scratchings so the ratings now should be 1 through 8. I have six columns of data that I want to be able to rerate after scratchings. Cheers Twodogs
|
|
#4
2nd September 2008, 10:02 AM
|
|||
|
|||
|
1 3 1 1 1 1
9 7 2 2 2 6 5 4 7 5 5 8 7 9 4 3 3 4 2 1 5 4 4 2 4 5 8 6 6 3 10 11 6 10 7 10 8 6 10 9 10 11 3 2 11 8 9 7 11 10 12 11 12 9 12 12 9 12 11 12 The Data looks like this in six columns and this is just one race. The cap being the scratched horse. Of course the data is columns unlike the way it is shown here.
|
|
#6
2nd September 2008, 04:42 PM
|
|||
|
|||
|
Sorry Crackone
I have no idea when it comes to Macros!! I do want to keep the number of runners in the same so deleting the line isn't at present an option. Could it be rerated if the is data relating to the scratched horses was deleted and left blank? Twodogs
|
|
#7
2nd September 2008, 05:08 PM
|
|||
|
|||
|
Quote:
As Moeee said it is hard without seeing. Do you have the meetings across the spreadsheet or down? How do you rate the horses (manually).
|
|
#8
2nd September 2008, 05:37 PM
|
|||
|
|||
|
The meetings go down the page so all columns are constant down the page.
Manually I just look at which horses are scratched and renumber the ratings in order from 1 up so to speak. Twodogs Last edited by Twodogs : 2nd September 2008 at 05:56 PM.
|
|
#9
2nd September 2008, 05:54 PM
|
|||
|
|||
|
Quote:
|
|
#10
2nd September 2008, 05:57 PM
|
|||
|
|||
|
Thanks for trying Crackone
Yes I tried that this morning but it is slow but it does do the job so to speak. It maybe the only way to do it but thought it worth asking around to see if it could automated somehow. Cheers Twodogs Last edited by Twodogs : 2nd September 2008 at 06:03 PM.
|
 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
