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.