Random sorting of list
 

Is it possible to sort a list automatically in a random order??

Kathrine

Random sorting of list
 

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.
--
Gary''s Student
gsnu200712


"Kathrine" wrote:

Is it possible to sort a list automatically in a random order??

Kathrine

Random sorting of list
 

"Kathrine" wrote:
Is it possible to sort a list automatically in a random order??

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---