COLUMNS A to F
H Team 30/12/07 $1.70 LOSS - no cnt > $1.60
H Team 30/12/07 $1.42 DRAW- 1st cnt-rules met
H Team 30/12/07 $1.47 LOSS - no cnt-1.47>1.42
H Team 01/01/08 $1.45 LOSS - 2nd cnt-rules met
A Team 02/01/08 $1.54 WON - no cnt-away game
H Team 02/01/08 $1.30 WON - no cnt < $1.40
H Team 03/01/08 $1.50 WON - "2" displayed
H Team 20/01/08 $1.41 DRAW - 1st cnt-rules met
H Team 20/01/08 $1.53 DRAW - no cnt-1.53>1.41
A Team 21/01/08 $1.59 LOSS - no cnt-away game
H Team 22/01/08 $1.53 LOSS - 2nd cnt-rules met
H Team 30/01/08 $1.45 DRAW - 3rd cnt-rules met
H Team 31/01/08 $1.42 LOSS - 4th cnt-rules met
H Team 01/02/08 $1.57 WON - "5" displayed
H Team 05/03/08 $1.45 WON - "1" displayed
What I'm trying to do is choose only one footy match for each unique date that meets my parameters to bet on, and to keep count of the amount of bets I place before I win!
The parameters are as follows;
* Have to be the lowest odds (ColD) but > than $1.40 and < $1.60.
* Be a home game (ColA).
* In the advent of same odds & same date, the team with the lowest alphabetical ranking should be counted.
As you can see in the last column the " " is the data I want displayed.
It shows that it took 2 legitimate bets before I posted my first win, hence "2" is displayed.
It takes another 5 legitimate bets before I get my next WIN, so "5" displayed.
The the very next bet I get another WIN straight up, so "1" is displayed.
Regards Peter
Bookmarks