Return different quantities of question types from a randarray.

[baileyb103]

Good morning,

This is a continuation from a previous question (found here). I do however now have another question about adding a feature to the sheet.

Do you know if it is possible to select 'x' amount of questions from User Group 1, 'y' amount of questions from User Group 2, 'z' amount of questions from user group 3, whilst still only selecting from the filtered options?

The reason for this is the course is progressive so they will need knowledge from previous user groups, but still focus the main efforts on the current user group, for example when they are on user group 3, they could have a 30 question paper with 5 questions from user group 1, 5 questions form user group 2, and 20 questions from user group 3.

Many thanks in advance for any help.

 

[Cubist]

It would be helpful if you could post the layout of your data.

 

[baileyb103]

It would be helpful if you could post the layout of your data.

Good morning, please find attached an image of the current formula (cell J2), I would like to pick say 5 from User Group 1, 8 from user group 2 and 2 from user group 4 for example.