Hi
the solution I know would invole a helper column with the formula
=RAND()
for all rows and sorting with this helper column. This should work

--
Regards
Frank Kabel
Frankfurt, Germany

"ckephart" schrieb im Newsbeitrag
...
That's basically it. I have existing worksheets of data that I would
like to
sort in random order. There are roundabout ways to do this with
formulas,
but this can be tricky, and does not work in all situations.