random numbers

  • Thread starter Thread starter Keith Partridge
  • Start date Start date
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
 
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
 
Back
Top