What I wish to do is for a Star to appear in Column E if the animal is Ranked 6th to 8th
I will manipulate the Data and the animals may change their ranking.

When I have done with the worst Ranked animal I will clear its D Cell.
Then I wish Column E to ignore the worst animal and put a Star in the 5th to 7th worst animals.
I was hoping that Column E would automatically ignore the D Cell if it was empty.

Attached Files

Dogs.xls (66.0 KB, 438 views)

will column C always stay the same Moee?,
You could use conditional formatting to highlight with say red traffic lights or Flags for 6-8 and 5th could be a yellow traffic light and green for the rest of the field, based on the ranking in column C

Hi Woof43

Column C is the current assessed Odds
They will change as I manipulate my data.
What I wish to do is concentrate on the 3 worst animals and have a separate Market based only with these 3 animals in it.

What I need is something like =If(D>(Count(D1 : D8)-3),"","*") or maybe =If(D>(Count(C1:C8)-3),"","*")

When I have the worst ranked animal at the Odds I believe it should be , then I wish to eliminate it from the Rankings.

would it be better to keep your original data, then create your new markets in adjacent cells based on whatever criteria, so you can see your changes

PS that #1 in that race is about 1.70 chance of leading.

Okay everyone
I'm good.

=IF(D1>(COUNT(D$1 : D$8)-3),"*","")

Yes.
What you are saying is pretty much what I am doing.

And i am well aware of the early speed of #1 and have taken it into account.
Its recent times at Geelong aren't nowhere near enough for it to be a Odds On Chance of winning.