Random sorting of list

G

Gary''s Student

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.
 
M

Max

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.
 
Top