Prev: Automatically hide/unhide rows
Next: Despite formula I use (for example SUM) result is always zero.
From: Chad on 23 Apr 2010 09:49
I have a 2 part question. I want to have a 1 question survey randomly filled
out by 200 people. Column A lists the 1 questions. Columun b has ABCDE
listed in cells B6 to b10. I would like 200 samples in columns c, d, e, etc.
How do I set this up so that they randomly Coose B6 to B 10.

Second part. On another spreadsheet, I have a similar situation, but the
user has 10 answers to select from and I want them to randomly select all
that apply. How would I do this? Thanks!

 | 
Pages: 1
Prev: Automatically hide/unhide rows
Next: Despite formula I use (for example SUM) result is always zero.