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