Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.

i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple. 

looking for formula based solution – not macro based. 

TIA!

​Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple. looking for formula based solution – not macro based. TIA!   Read More

​