Home » Questions » Computers [ Ask a new question ]

How do I generate 300 lists of 12 numbers between 1 and 33 without repeats in excel

How do I generate 300 lists of 12 numbers between 1 and 33 without repeats in excel

I am conducting a study in which each of the 300 participants are rating 12 prototypes each. We have 33 prototypes in total. How would I generate 300 lists each containing 12 random prototypes from the 33 in excel ensuring that no list contains a duplicate and all prototypes appear at least 100 times?

Asked by: Guest | Views: 305
Total answers/comments: 1
bert [Entry]

While it is definitely possible to do in Excel, it would be difficult since VBA is tricky to work with. If you need a more powerful spreadsheet tool you might want to look at Resolver One