golf league schedule 20 teams of 40 players

berbs

New Member
Joined
Mar 17, 2019
Messages
11
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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,532
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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:

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,998
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


Download workbook : https://www.amazon.com/clouddrive/share/BlifvOEASVltambYvKdV36mWvfOeSJvA1JpPDahfbfG
 

berbs

New Member
Joined
Mar 17, 2019
Messages
11

ADVERTISEMENT

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.



Thank you for your help.
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,532
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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:

berbs

New Member
Joined
Mar 17, 2019
Messages
11
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?
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,532
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,383
Messages
5,635,942
Members
416,889
Latest member
dhegs

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top