Generating Statistics with Excel

[bracket]

I am trying to create a scissor paper stone game with excel.
Have used the random functions to create gameplay with the Computer

However, I want to store the statistics or history of the winners of the
last 20 games, either the player or computer.

How am i supposed to do this?

[Tushar Mehta]

Put the result of each play in some cell, say, the first empty cell in
a column.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I am trying to create a scissor paper stone game with excel.
> Have used the random functions to create gameplay with the Computer
>
> However, I want to store the statistics or history of the winners of the
> last 20 games, either the player or computer.
>
> How am i supposed to do this?
>

[bracket]

Hmm,

i want a list of the results of the last 20 games.
Each time i press F9..
the list will be updated by a new row.

I can then press reset, to reset the entire history.

How can that list be auto generated?


"Tushar Mehta" wrote:

> Put the result of each play in some cell, say, the first empty cell in
> a column.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > I am trying to create a scissor paper stone game with excel.
> > Have used the random functions to create gameplay with the Computer
> >
> > However, I want to store the statistics or history of the winners of the
> > last 20 games, either the player or computer.
> >
> > How am i supposed to do this?
> >
>