I have a random function which generates an integer from 1-9 with each
screen refresh.

Would I be able to tally how many times each number was generated? What
I imagined was setting up an additional COL 'Results' and then trying to
increment an

-if [Cell Ref of Rand Function]=1 then x (cell containing tally of
incidence of result 1) =x+1

if [Cell Ref of Rand Function]=2 then x (cell containing tally of
incidence of result 2) =x+1 - etc. etc.

style argument. Thus I could see how often a number was picked by the
RAND.

Is this possible, and how might I do it? Any comments gratefully
received.

Thanks for looking!

Baldy


--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile: http://www.excelforum.com/member.php...fo&userid=1260
View this thread: http://www.excelforum.com/showthread...hreadid=387444