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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Randomise slides and have an infinite loop 0
Selecting value contingent on other field 1
DLookUp 1
Random number generation 3
Yet another Q 4
how do I create and extract a random order from list in Excel? 5
Randomise the positions of rows in a DataTable 2
Copying by Sequence Number 1

Back
Top