Simple, if var = 1 then restart count

[TMorville]

Hi, i have a dataset with people rolling a dice, and i need to label them with a game number

I have a varible called trialCount. This goes from 1 to 13, and everytime it equals one, its a new game number.

Basically this is the stucture i have - except for game number:

trialCount     totalTrialCount     gamenumber (Dont have, but want!)

     1                    1                         1

     2                    2                         1

     3                    3                         1

     4                    4                         1

     1                    5                         2

     2                    6                         2

     1                    7                         3

     1                    8                         4

     1                    9                         5

     2                    10                       5

     3                    .                         5

     4                    .                         .

     5                                              .

     6

     7

     .

     .    

So basically what i would like is something conceptually like:

When trialcount = 1

then gamenumber = "some loop that counts what game number we are at, and puts that number in"

until trialcount = 1 again, then start over

I can't really work this out. I can do a simple count + 1, first.count, but that dosen't really work here.

Hope you understand where im coming from!

Thanks

toby

[art297 · Accepted solution]

why not just?:

if trialCount eq 1 then GameNumber+1;

[Haikuo]

Exactly, or equally:

Gamenumber+(trialCount eq 1) ;

Haikuo

[TMorville]

God i think i had too much coffee this evening.

Thanks for pointing out the obvious.

T