Random numbers
Posted by Camilla on June 15, 2001 5:22 AM
I have the numbers 1 - 10 and I want Excel to mix the
numbers in a random order. The chance that number 2 is
the first in the row has to bee the same as if it was 5. Please help me.
Thanks
Camilla
Posted by Aladin Akyurek on June 15, 2001 6:14 AM
Camilla,
The following will give you a random series between 1 to 10 no repeats.
In A1 enter: =RAND() [ copy down up to 10th row ]
In B1 enter: =RANK(A1,$A$1:$A$10) [ copy down up to 10th row ]
The following will similarly give you a random series between 1 to 10 with repeats.
In C1 enter: =RANDBETWEEN(1,10) [ copy down up to 10th row ]
PS. The first one is a "reuse" of an answer by Mark W.
Aladin
