How to keep random number from changing using RANDBETWEEN?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
Try setting recalculation to manual "TOOLS/OPTIONS/CALCULATION/MANUAL"
(Assuming this is compatible with what you want to accomplish).
Stephen Powell
 
Back
Top