How to save random numbers?
wrote:
I have been able to generate numbers from 1 to 100 with two
decimal places but I can't figure out how to create a history
of previously generated numbers.
Enter the following formula into A1:
=RANDBETWEEN(100,10000)/100
Copy A1 into A2:A1000. Copy A1:A1000, then use Paste-Special-Value to put
the values (not the formulas) back into A1:A1000 or somewhere else.
|