So in your example of 12 runners, would every rating number that was above the scratching become 1 less?

In the 1st column the scratching was rated 6.
Would all those above 6 rated become 1 less than they were before the scratching?
And in the 2nd column it was rated 8.
would all those in that column above 8 become 1 less?

If that is so, In the example, what is actually in the cells of Number 1 1st row where you have 1 3 1 1 1 1 ?
If there ain't no Formula then how did those numbers appear in the cells?

Hi Moeee,

The data comes from a CSV download from a rating site (Best I don't mention who) They do updates of their PDF file after scratchings but not the CSV file.
So if the horse scratched rated 6 every horse rated above 6 would reduce by 1.

I paste the csv file contents into my own spreadsheet with formulas to extract what I require.

I could email you a sample of the file if that helps?

Twodogs

Thanks for your help guys!

I will try another forum where I can give more details which might help getting an answer.

Cheers
Twodogs

Good Luck with it twodogs.

But I tell you what.
Whatever time you save after you get it sorted, you are still gonna spend the gained time doing more Punting stuff.

I thought I could gain 20 minutes when I eventually found a shortgut but I just used the gained time to twiddle and tweak even more.

And I'M STILL LOSING just the same :)

So very true Moeee,

For all the quicker ways we find to do things the more likely we are to find other distractions.

Cheers
Twodogs