"LAY IN PLAY" triggers twice

[GaryRussell]

Since one market is win and the other is place my example comparison won't work as it is.

You could do the following for example:-

Cell W1 =

Code: Select all

=LEFT(A1,SEARCH(":",A1)+2)

Cell W2 =

Code: Select all

=LEFT(Sheet1!A1,SEARCH(":",Sheet1!A1)+2)

Then your formula could be as follows.

Code: Select all

=IF(AND(Sheet1!T5<>"",$W$1=$W$2),"LAY-IP",IF(T5<>"","CLEAR",IF(AK$1<0.0001041666,"",""))))

[dealbanker]

Thank for the explanation Gary,
I misunderstood the `race name' comparison and your formula example did it for me. So far there have been no additional triggers, full day test on Saturday.