Help with my trigger when there is NR or Withdraw

[mickyxx1]

hi there, i need help with my trigger which is

=IF(AND(AA5=1,F5>1.05,F5<1.7,$F$2="",COUNTBLANK(T$5:T$50)=46),"BACK","")

the problem is if there is NR or WITHDRAW horse in the market race the trigger doesn't fire any bets, given all conditions are met which i don't understand. Can help pls

[brumbie]

What is in column AA?

[mickyxx1]

it's a unique Rank.
=IF(F5<>"",RANK(F5,F$5:F$50,1),1000)

[mickyxx1]

Sorry that was on Y let me clarify

Y =IF(F5<>"",RANK(F5,F$5:F$50,1),1000) (Rank)

Z =Y5+0.01 (Tie Break)

AA =RANK(Z5,Z$5:Z$50,1) (Unique Rank)

[brumbie]

The trigger seems ok,i think the problem
has to be further back.A non runner will just give you noughts across the row.

[mak]

when there is a non runner does your excel produce signs like ## or #n/a etc?

if yes, probably you will have to check your formulas and add and if statement
for example

if in R column you have =f5 replace the formula with something like
=if(f5="","",f5) etc

also you can replace the ranking formula with this one from Osknows
=IF(F5="","",(RANK(F5,$F$5:$F$55,1)+COUNTIF($F$5:F5,F5)-1))

finally this formula count the horses without non runners if it helps
=COUNTA(A5:A55)-COUNTIF(A5:A55,"*(NR)*")