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