Random sorting of list

  • Thread starter Thread starter Guest
  • Start date Start date
If your list is in column A, in column B enter:
=RAND()
and copy down as far as the list in column A.

Then sort both columns by column B.
 
Kathrine said:
Is it possible to sort a list automatically in a random order??
Click to expand...

One play ..

Assuming the items are listed in A1:A5
In B1: =RAND()
In C1: =INDEX($A$1:$A$5,RANK(B1,$B$1:$B$5))
Select B1:C1, copy down to C5. Hide away col B.
Col C returns a random scramble of the items in A1:A5
Just press F9 to regenerate.

---
 

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

Randomizing 3
How to select a list of text, and then put it in a row alphabetic. 1
Order numbers from smallest to largest 6
Random Sort 2
How to sort al list in random order for sampling? 1
Randomly assigning Data 1
How can I sort a selection of cells into random order? 2
sorting 2

Back
Top