Random Number

[Dan Tschippert]

I am trying to make a spreadsheet that would randomly select and record a 3
digit number on demand.

I want to use this for drawings to replace a lottery type ball machine.

I need it to keep track of the time the number was generated and the number
and not recalculate the numbers at all. It would just develop a "list of
numbers" either at predetermined time intervals or when I would press a key
or click a button.

Anyone have any ideas? I did poke around and found random number generators,
and they seem to come close, but aren't exactly want I need.

Thanks

Dan

 

[JE McGimpsey]

one way:

Assume you want to update the number daily.

On another sheet (say, Sheet2). Enter 0..999 in A1:A1000. In B1, enter
=RAND(), and copy down to B999. Sort columns A & B on column B to
randomize the numbers.

Back on the original sheet enter

A1: =IF((TODAY()-DATE(2004,8,24))>=ROW(), INDEX(Sheet2!A:A,ROW()), "")

and copy down. A new number will appear in the column each day.