Random Sort

H

hotherps

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
 
N

Nikos Yannacopoulos

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
 
Top