Victor
12-31-2008, 10:28 AM
I upload a Domino.xls file.
What I need is advice in filling automatically the columns with name " Num Jugada" with the number that corresponds to the winning game.
For example:
1-If the frst game to win is " Nosotros" I write a 1 in D1.
2-If " Nosotros win again in cell D2 I write 2
3-If "Ellos" win the third game I write 3 in cell L1
4-If " Nosotros" win the fourth game I write 4 in D3
As you see there is a sequence in the numbers assigned but the cell where is assign depends of who wins the game.
Any ideas how can I write this number automatically.
I try with if but do not have exit.
Then try with VBA code but have no idea to where to begin.
Any advice of which method I should use to do it automatically?
Thanks for the help.
Victor
What I need is advice in filling automatically the columns with name " Num Jugada" with the number that corresponds to the winning game.
For example:
1-If the frst game to win is " Nosotros" I write a 1 in D1.
2-If " Nosotros win again in cell D2 I write 2
3-If "Ellos" win the third game I write 3 in cell L1
4-If " Nosotros" win the fourth game I write 4 in D3
As you see there is a sequence in the numbers assigned but the cell where is assign depends of who wins the game.
Any ideas how can I write this number automatically.
I try with if but do not have exit.
Then try with VBA code but have no idea to where to begin.
Any advice of which method I should use to do it automatically?
Thanks for the help.
Victor