"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
---