Forum Discussion

LearningFrog15's avatar
LearningFrog15
Copper Contributor
Jan 30, 2023

Help! Index, RandArray, Sequence Formulas

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.

No RepliesBe the first to reply

Resources