Originally Posted by xptdriver

Gday All...

I don't think I have explained what I do properly (my fault).

I arrive at my final price using this formula =F6/E6*0.86 That is arrived at from data also in C and D ... F and E are just totals.. ( confusing myself here)

Column A Holds the race name example :
Race 1 2:00 PM Sky Channel Rating Services Maiden Handicap 2yo

Also in Column a (Next lines down) are the horse numbers

In column B are the horses name

I leave a 1 line space between each race

When I grab the formula (above) and fill down column G, where there is the Race name, and where the 1 line space is.. that #DIV/0! error appears..

So i was wondering how to get rid of it.. what i do at the moment is just work my way up or down the sheet hi lighting errors and using "clear contents". It works but I was hoping there was another way..

Sorry to be such a dill