Is it possible/difficult to sort a selection of data at random? I have
range of data A10:Z10 the first column has a person's name, the secon
has their start time. In the remaining columns assignments are given.
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 th
same assignments.

Thank

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

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/

That worked great! Thanks so much for your help

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