Hi,
For my own use and to replicate a childhood game I am trying to construct a cricket match.
So far I have:
A21=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))) to return scores between 0 - 6 including OwZhat
Then =IF(A21="OwZhat",A19,"") which in turn triggers
A19 =CHOOSE(RANDBETWEEN(1,2),"OUT","NOT OUT")
If OUT then
B19 =(CHOOSE(RANDBETWEEN(1,6),"LBW","RUN OUT","CAUGHT BEHIND","STUMPED","BOWLED","BOWLED")) to decide how the player(batsman) is out.
All this works, my problem is the scoring from A21 , how to assign a running total to one of two players(Batsman)? I would like to increment a count until the player is out. Then assign the scores from A21 to the new player(batsman).
I really do appreciate your time in reading this and hope it makes sense. Any help is much appreciated as I have lost the plot with this.
Many thanks
Steve
For my own use and to replicate a childhood game I am trying to construct a cricket match.
So far I have:
A21=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))) to return scores between 0 - 6 including OwZhat
Then =IF(A21="OwZhat",A19,"") which in turn triggers
A19 =CHOOSE(RANDBETWEEN(1,2),"OUT","NOT OUT")
If OUT then
B19 =(CHOOSE(RANDBETWEEN(1,6),"LBW","RUN OUT","CAUGHT BEHIND","STUMPED","BOWLED","BOWLED")) to decide how the player(batsman) is out.
All this works, my problem is the scoring from A21 , how to assign a running total to one of two players(Batsman)? I would like to increment a count until the player is out. Then assign the scores from A21 to the new player(batsman).
I really do appreciate your time in reading this and hope it makes sense. Any help is much appreciated as I have lost the plot with this.
Many thanks
Steve
