randarray

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...

Hello everyone I need you help regarding sorting in an array. Let say that I create an array with command randarray(18,7,3,20) how can I sort the numbers that the smaller with obviously is 3 to be at the top left corner of the array and the biggest (20) be at the right bottom . I want the sort...

Hello This is a list contains some values, I actually want this always randomly changed in new row without duplicates, I use this formula, this formula generate new random list than I manually sort and rearrange the list, and row wise its not duplicate, how I do this with formula, I attached...

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...

Hello to everyone. I saw these new features on microsoft office web sites. Are not available yet? I Use office 2016(365). FILTER function RANDARRAY function SEQUENCE function SINGLE function SORT function SORTBY function UNIQUE function