ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to select other random cells (https://www.excelbanter.com/excel-worksheet-functions/262280-how-select-other-random-cells.html)

chad

How to select other random cells
 
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!



All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com