Random Sort

  • Thread starter Thread starter hotherps
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify working code to expand the output. 5
MACRO RUN random percentage and copy of column values 1
Six columns randon no.'s no dupes 6
code for sorting data 6
Worksheet sorting code/technique advise 55
random mumber array 3
How can I sort contents of one column based on the contents ofanother column? 1
Array Randomly Sorted 4

Back
Top