Use a spare column and fill it with built-in function RAND(), which returtns
random numbers between 0 and 1. Then you can sort on that column. When you
need a new random sorting, just press F9 to force a new calculation, and you
will get new random numbers on which to sort.
Needless to say, if this is going to be a frequent task, you can record the
recalculation/resorting actions in a macro, without needing to write any
code yourself.

HTH,
Nikos

"hotherps " wrote in message
...
Is it possible/difficult to sort a selection of data at random? I have a
range of data A10:Z10 the first column has a person's name, the second
has their start time. In the remaining columns assignments are given. I
would like to be able to sort by the first column at random.

It will make sure that the same people are not constantly doing the
same assignments.

Thanks


---
Message posted from http://www.ExcelForum.com/