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