OK here is the example I want to create - imagine having a 4digit combination lock, and you want to know all the different combinations it could be. You want them printed seperately so you can see them all.

Now what I am doing involves the same concept only I need to get all the unique combinations where one is not being repeated more than once going backwards or forward.

ie. 0001 = 0010= 0100=1000 all these translate into 1 unique combination.

I want to host a series of games where I have 32 players, 8 teams of 4 players, divided into 4 tables. each week the player combination changes. And having one table be the same as the previous weeks will not work. The series is a 24 week series. And I also can't have the same team members playing at the same table.

I have started with "=index(array,Mrand()+1) after creating a list of all the teams and their players but I'm stuck because, I am going to have to check manually for repeats.

Any ideas would help. Thank you...Rich

Now what I am doing involves the same concept only I need to get all the unique combinations where one is not being repeated more than once going backwards or forward.

ie. 0001 = 0010= 0100=1000 all these translate into 1 unique combination.

I want to host a series of games where I have 32 players, 8 teams of 4 players, divided into 4 tables. each week the player combination changes. And having one table be the same as the previous weeks will not work. The series is a 24 week series. And I also can't have the same team members playing at the same table.

I have started with "=index(array,Mrand()+1) after creating a list of all the teams and their players but I'm stuck because, I am going to have to check manually for repeats.

Any ideas would help. Thank you...Rich

Last edited: