At 14:33 12/06/2007 -0700, Neil Short wrote:
I have a little drill sheet of questions - one question per line in
a column. I would like to scramble the column.
How?
Thanks.
In another (adjacent?) column, insert the formula
=RAND()
and then drag the fill handle to copy this same formula into the
cells in the new column corresponding to the rows you have filled in
your questions column. This fills the new column with pseudo-random
numbers. Now select both columns and go to Data | Sort... . Under
Sort Criteria, select "Sort by" to be the new column with the random
numbers. (It doesn't matter whether you sort ascending or
descending.) Your questions will now have their order scrambled.
What you do next is adjustable. You could leave the numbers column
in place (but just not print it?), or delete the values or even the
column. Alternatively, you could hide the column in order to be able
to return to it later and perhaps use it again. If you change any
part of the sheet, new pseudo-random numbers will be created, and you
could then scramble the list again in a different order.
To hide a column, select it and use Format | Column > | Hide or
right-click on the column header and then select Hide from the
context menu. To reveal a hidden column, select columns spanning the
hidden column and repeat the above, but using "Show" instead of "Hide".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
