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?

This isn't the sort of thing Excel is good for, but you might be able to use the VB integration to do it. 


Simplest way:



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 

