Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
MS Excel 2000
Used the function =INT(RANDBETWEEN(1,5) to generate a list of random numbers. Protected the sheet and left the the range the function is in locked. Other parts of the sheet unlocked. Why is it that when I enter data in unlocked cells that the list of random numbers changes. I needed to protect my random generated data from changes so I copied it as values to another range and locked that range so no changes can be entered. But I was wondering why the cells with =INT(RANDBETWEEN(1,5) in them change when I am entering data in other areas of the sheet. Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) | |||
how do you change invoice numbers automaticly | New Users to Excel | |||
generate random numbers | Excel Worksheet Functions |