Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Selection
Hi,
Please could any one prepare a macro for me with following details: I have data base of about 100 questions divided into various groups. I want a macro where in every time I get a set of randomly selected 20 questions representing questions from all the groups. In column B: I have Name of various groups In column C: I have questions, there could be 5-6 questions in each groups (there should be flexibility as there can be any number of questions in each groups ranging from 1 to 25-30) I want a question paper for a student in a new excel file. There should be a flexibility in terms of number of questions available in data base. There could be 80 as well as 150 any number. There should even be flexibility in selecting number of questions required for a particular student. Cheers, Mandeep Dhami |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random Selection | Excel Discussion (Misc queries) | |||
Random Selection | Excel Worksheet Functions | |||
Random Selection | Excel Worksheet Functions | |||
Random Selection | Excel Programming | |||
Random Selection | Excel Programming |