random numbers

[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

 

[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