Returning only visible data for RANDARRAY

[baileyb103]

Hi. I am creating a question bank for a module that is made up of multiple class studies. I have created the full question bank and I am using RANDARRAY function to return a random test paper. Initially I just wanted to create an end of module test but now I've been asked if I can use the bank to create random tests for each class study. I have attempted this by adding in a column with the class study number for each question and filtering, but the RANDARRAY returns results from all the data not just the visible data. Is there anything I can add to the formula or do to the sheet to only return data from the visible cells? The current formula looks like this... =INDEX(SORTBY(C2:F118,RANDARRAY(ROWS(C2:F118))),SEQUENCE(H1),{1,2,3,4})

 

[baileyb103]

Sorry I've not retried yours as yet...I'll try it and let you know...my app might have updated to allow that function

 

[baileyb103]

In what way didn't the formula I suggested work?

Thank you @Fluff your is working on my home laptop...I'll try tomorrow on my works laptop which is a closed intranet so I'll have to see if the Excel app supports it. But thank you.

 

[Fluff]

Ok
If you don't have the TAKE function at work, let us know & it can be reworked.

 

[baileyb103]

Ok
If you don't have the TAKE function at work, let us know & it can be reworked.

Would I be able to add it using the VBA things? (I have done my 1st of these today on another task I've got going on).

 

[Fluff]

Do you have the TAKE function?

 

[baileyb103]

Do you have the TAKE function?

Yes just tried it now and works a treat...thank you

 

[Fluff]

You're welcome & thanks for the feedback.

 

[baileyb103]

Good morning,

Fluff thank you for your help with the above formula it is working a right treat. 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.

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks

 

[baileyb103]

As this is a totally different question, it needs a new thread. Thanks

This has been done... Return different quantities of question types from a randarray.