I've created more confusion today then there was exactly 2012 years ago.

These ain't Ratings Woof43.
I'll try to explain.

I have video clips.
Each Video Clip has a number.
The Hard Disk can only hold 1,000 clips.

So at the end of each day , I need to delete a number of clips to allow room for tomorrows recordings.
So if I wish to tape 10 Races tomorrow , I need to delete 10 Clips.
And The Hard disk relabels the original titles Number as the old number minus whatever number I delete.

And the new Clips are then titled , 991 , 992 , and so on.

The idea of the numbers is so I look up a dog in my database and I press one of its Numbers on the dvd player , and I can watch its traits.

I'm not sure if you are aware of my memory , but I barely have one.
Its a terrible handicap to my handicapping.

why bother when dartfish tv has them all for free

I have 1.5 Gig per month to mess with , that gets chewed up much too quickly.
My Brodband is super super slow in this area due to fringe reception with my dongle.
Its just so much more convenient and quicker having my own copy of the race.
I can watch the replay as many times as I wish immediately after the race.

I actually did have a play with that Darfish , but I think it didn't work unless you were actually on line.
Plus I'm not sure if there is a substantial delay from when the race video being provided.
At the minute , I haven't even bothered installing Silverlight.

ok, explains why , when i ran a few of your dogs thru a percentile ranking it just didnt work out

I seem to be having problems with cells and Formulas that depend on the contents of that cell.
When there is a zero in a cell the Formula works.
When there is a Number , and then the number is cleared then sometimes the Formula thinks there is a zero in the cell and sometimes it thinks there is a Null in the cell.
And sometimes if I type a word inthe cell , then the Formula thinks there is a number greater than zero in the cell.

This Formula is preceded by the IF Statement.

moeee, all clear now, tomorrow's a writeoff for me (races then the footy), but Sunday I will be happy to sort it, unless some kind soul chips in in the meantime.

copy the formula and paste here, will make it easier to understand

Does this work?

Attached Files

Meadows 5.xls (337.5 KB, 405 views)

That looks good to me...

good work

OMG RAVEN!!!
I think not only have you answered my original question , You appear to have answered my next question.

U DA MAN.
May that you Raven grow up to be an Emu and kick some HUGE Ass.