# golf league schedule 20 teams of 40 players

#### berbs

##### New Member
new to mrexcel but would like some help putting together a golf league scheduler for a 40 player / 20 team league. 18 total weeks. am new to formulas in excel and a general beginner but use excel daily but not to its full potential. want to learn more. thanks.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
HI berbs,

Welcome to the MrExcel Forum.

The best way to learn and get some help would be to begin how you did, by explaining the problem. Now lay out how you envision this schedule to look, and what it would do. After you have that in your mind, how might you get there.

With that, you could get some help and feedback from the other Forum readers as now they know what you are trying to accomplish. It will also help you to help yourself.

Last edited:
Code:
``````Sub PickTeams1()
Dim InA As Variant
Dim OutA As Variant
Dim r As Double
Dim n As Long
Dim rw As Long
Dim col As Long

With Cells(3, 1)
InA = Range(.Cells, Cells(Rows.Count, .Column).End(xlUp)).Value
End With

Randomize

ReDim OutA(1 To 2, 1 To UBound(InA, 1) \ 2)

For n = UBound(InA, 1) To 1 Step -1

r = Int(Rnd() * n + 1)
rw = 1 + (1 And rw)
col = col + (1 And rw)
OutA(rw, col) = InA(r, 1)
InA(r, 1) = InA(n, 1)

Next

Range("D3").Resize(2, UBound(OutA, 2)) = OutA

End Sub``````

HI berbs,

Welcome to the MrExcel Forum.

The best way to learn and get some help would be to begin how you did, by explaining the problem. Now lay out how you envision this schedule to look, and what it would do. After you have that in your mind, how might you get there.

With that, you could get some help and feedback from the other Forum readers as now they know what you are trying to accomplish. It will also help you to help yourself.

Happy to help. Try to think of what you want your end product to look like and then try to kind of "Reverse Engineer" that...

Thanks for the feedback.

Let us know what you come up with...

Last edited:
Happy to help. Try to think of what you want your end product to look like and then try to kind of "Reverse Engineer" that...

Thanks for the feedback.

Let us know what you come up with...

Ok. I have all my weeks of league and the teams playing whom ex: team 19 v team 2 for example. i have my players per team listed. don't want to type all the names per week, per match for 18 weeks. i have been trying to search youtube for what formulas to use to populate the team player names into the "team name" cell for each week. vlookup?? i don't know formulas well at all. i am rather good at excel but i feel i am using only 1% of its capability per se. does this make sense?

tried taking a screen shot to show you and I couldn't even get that right. how my doing?

Can you show me how you have your data set up. Such as what are your headers going across your sheet and what is the range (ex: "A1:N1"). Are the players going down a column, and where are the teams located. I can't see your sheet, so the more information you supply the better. You could also share a sample on one of the many available sites as has already been done in this thread.

Replies
5
Views
120
Replies
1
Views
405
Replies
8
Views
426
Replies
11
Views
4K
Replies
1
Views
27

1,216,415
Messages
6,130,471
Members
449,583
Latest member
CatMama9

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back