Avoiding betting on a selection more than once

[psilocybin]

Is it possible to check if you already have a bet on a horse.

[mak]

place this formula in an empty column for example aa5
=IF(T5="";"Bet";"NoBet")
"drag" this formula down to a55

this formula reads if T5 (bet reference) is empty then BET otherwise NoBet

In your trigger column place a statement something like this

cell q5 =if(AA5="BET";"your trigger...";"wait")

** if the formula won't work replace ; with ,

hope that helps

[mak]

sorry can't edit..

if it's ok that formula "drag" down to q55 the q5 formula

[osknows]

Mak's method works fine if you don't plan to clear out the bet references. There is a method in excel which can retain the memory of whether a bet has been placed after a cell has changed. This is a neat method if you prefer not using vba

In Excel goto Options/Formulas and enable iterative calcualtions and set the maximum iterations to something large like 32,767 (max limit might be lower in excel 2003)

This will allow circular referencing of cells

Then in cell AA5 enter the following and drag down
=IF($AA$1="Reset","",IF(OR(T5<>"",AA5="Bet Placed"),"Bet Placed",""))

If any character is placed in T5 then 'Bet Placed' appears in AA5. If T5 is then cleared 'Bet Placed' is still held in AA5. AA5 Can then be cleared by placing 'Reset' in cell AA1

[mak]

Os
i was trying to make an iteration formula some time ago but couldn't understand well enough what i was supposed to do

i will "play' with your example tomorrow
thanks