How to keep random number from changing using RANDBETWEEN?

T

TXlimogirl

I am trying to generate a set list of random numbers between 1 and 42 using
the RANDBETWEEN formula. The problem is everytime I click another cell
anywhere in the sheet or even open and close the sheet after saving it, the
random numbers change again. How can I keep the random numbers from changing?
Any help would be greatly appreciated! Thank you!!
 
S

Stephen POWELL

Try setting recalculation to manual "TOOLS/OPTIONS/CALCULATION/MANUAL"
(Assuming this is compatible with what you want to accomplish).
Stephen Powell
 
P

Peo Sjoblom

Copy and paste special as values in place once you are done

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANDBETWEEN() 9
How can I use the same random number twice in the same formula? 2
How to save random numbers? 3
Using "=randbetween" to select a number from a range of cells 4
Section and Page numbering 0
RANDBETWEEN 6
eliminate negative value from normal random number distribution 4
Random numbers from several ranges 3

Top