Lets say I have 100 exercises and in each exercise there are five questions each.
I want to randomly select 7 exercises and for the corresponding seven exercises i want to randomly select only two questions.
Please help by giving the excel formula.
Thanks,
Gilbert.
Bookmarks