Randomly generate 26 people into teams of 4 people playing 4 matches over 4 days

[THECAPTAINEGHAM]

How can I generate 26 people into teams of 4 people playing

 

[ExcelToDAX]

26/4 = 6.5, so where would the .5 people go?

 

[DanteAmor]

Hi @THECAPTAINEGHAM , you wrote your question without much desire to find an answer, without examples of how your data is, without examples of how you want the result, but what if in the following ones you find the answer.

Cycle Count Generator

I am wanting to create a random pick generator that picks 15-20 numbers from a list without repeating and keeping track of the picked numbers and not picking them again in future picks. But will auto reset once all the items in the list have been picked. If possible.

www.mrexcel.com

Count how many names in each column for random output

I have two sheets first is "Inscrp" where I put the names depending on categories in different columns Second is "Tirage" where I see random names appears from each category HowMany = 5 in the code represent the number of names to be picked randomly The problem when I write less than 5 names...

www.mrexcel.com

VBA Generate random 10 Group of 5 numbers

Hello, Looking VBA solution which generate random 10 group of 5 numbers using all 50 numbers in cells D2:H11 List of numbers is in cells A2:A51. If all numbers are used in to cross check C1 will show sum of 50 numbers = 1275 Example…...

www.mrexcel.com

 

[THECAPTAINEGHAM]

Sorry. I can clarify further, I hit the enter button so did not finish my message. This is for lawn bowls.
I need to select 24 from 26 and rest 2 of 26 and there are 4 matches
the 24 at each match are split over teams of 4 and we select a different team of 24 for each match with nobody playing with the same people more than once

 

[Logit]

In a regular module paste :

Sub refresh()
    Worksheets("Team Generator").Calculate
End Sub

Attach the above to a button on Sheet1.
Sheet one should look like below image.

Range G2:J7 each have a different formula that create the team members. The formula for one of the cells is :

=IFERROR(IF(G$1<>"",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F2)-1))),""),"")

You can download the example workbook here : Internxt Drive – Private & Secure Cloud Storage

Best wishes ...