Jan 30 2023 07:05 AM
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.