random numbers

K

Keith Partridge

Is there a way to use the'Rand' ,( randomise), function
in Excel.
IE: enter 45 numbers in a column and have them randomised in another column
 
J

Jerry W. Lewis

The RAND() function returns random numbers between zero and one. To
randomize a group of numbers that you supply, enter your numbers in on
column, enter =RAND() in another column, and sort both columns by the
second column.

Jerry
 
Top