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.