Shuffle numbers

Posted by Kristof on January 02, 2001 1:52 AM

Does anybody know a formula which kan shuffle a range of numbers?

Posted by Dave on January 02, 2001 4:30 AM

Hi Kristof

If you want to return a random number from a range of numbers then you could use:=RANDBETWEEN(MIN(H1:H100),MAX(H1:H100))

Dave

OzGrid Business Applications

Posted by Celia on January 02, 2001 5:41 AM

Carlo
If your numbers are in Column A, put in Column B the formula =RAND().
Select Columns A & B and sort by Column B.
The numbers in Column A will be reshuffled randomly.

Have a look at RandUnique.xls at :-
(broken link)

Celia