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?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 

