MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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