Help! Index, RandArray, Sequence Formulas

Copper Contributor

Here's the formula that gets me a single column of what I need (however I need 4 more columns that don't duplicate from the previous columns): =INDEX(RANDARRAY(90,1,1,5,TRUE),SEQUENCE(90))

 

Hoping excel can do what I'm in need of. I'm trying to create a randomized schedule for round table discussions. I have 90 people who will be visiting each of the 5 tables. I do not want the same group of 18 people stuck together for each of the 5 rounds, obviously some duplication is acceptable. Am I even close to the right path? Can this formula be expanded across columns that won't duplicate the numbers in the previous columns? Any help is appreciated. Thanks.

0 Replies