Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random numbers repeating
John T wrote...
I'm using random number generation using randbetween(0,10). Is there a way of stopping it from displaying the same number twice in a row? No, because there's nonzero probability that drawing from 0..10 with replacement will produce duplicates. If you could live with circular recalc, run the menu command Tools Options, select the Calculation tab in the Options dialog, check the Iteration box and set Maximum iterations to 1. Then try the following formula in cell A1. =MOD(A1+RANDBETWEEN(1,10),11) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
random numbers repeating
On 23 Jan 2007 12:49:04 -0800, "Harlan Grove" wrote:
John T wrote... I'm using random number generation using randbetween(0,10). Is there a way of stopping it from displaying the same number twice in a row? No, because there's nonzero probability that drawing from 0..10 with replacement will produce duplicates. If you could live with circular recalc, run the menu command Tools Options, select the Calculation tab in the Options dialog, check the Iteration box and set Maximum iterations to 1. Then try the following formula in cell A1. =MOD(A1+RANDBETWEEN(1,10),11) Thanks for your suggestion, it almost works but throws up other problems in the file. Cheers John T To reply by email take out "the rubbish" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
random numbers repeating
The standard way do sampling without replacement is to list the available
values (0,1,...,10), in the next column put random numbers (e.g. =RAND(), but then Copy/Paste Special Values to keep them from recalculating). Sort both columns by the random numbers, then select from the now randomized list of integers between zero and ten. Jerry "John T" wrote: On 23 Jan 2007 12:49:04 -0800, "Harlan Grove" wrote: John T wrote... I'm using random number generation using randbetween(0,10). Is there a way of stopping it from displaying the same number twice in a row? No, because there's nonzero probability that drawing from 0..10 with replacement will produce duplicates. If you could live with circular recalc, run the menu command Tools Options, select the Calculation tab in the Options dialog, check the Iteration box and set Maximum iterations to 1. Then try the following formula in cell A1. =MOD(A1+RANDBETWEEN(1,10),11) Thanks for your suggestion, it almost works but throws up other problems in the file. Cheers John T To reply by email take out "the rubbish" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate Random numbers from a pre-defined set | Excel Worksheet Functions | |||
Generate Random numbers from a pre-defined set | Excel Worksheet Functions | |||
Generation of random numbers and sum of those with a condition | Excel Worksheet Functions | |||
Random Numbers | Excel Worksheet Functions | |||
Random list (1-45) without repeating numbers? | Excel Worksheet Functions |