Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 16th 08, 10:39 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1
Default how do I make a sports schedule

i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE

  #2   Report Post  
Old October 17th 08, 10:12 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,646
Default how do I make a sports schedule

You gave not very much details, but if you have a list of teams in A2:A? then
this macro creates a combination of opponents for each team, then you can put
dates of matches in cells B1, C1, etc.


Sub sched()
Dim teams As Range, t As Range, e As Range
Noofteams = Range("A" & Rows.Count).End(xlUp).Row
Set teams = Range("A2:A" & Noofteams)
For Each t In teams
nexte = 0
For Each e In teams
If t < e Then
nexte = nexte + 1
Cells(t.Row, nexte + 1).Value = e.Value
End If
Next e
Next t
End Sub


Regards,
Stefi

„SHOETAC” ezt *rta:

i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE

  #3   Report Post  
Old October 18th 08, 04:26 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default how do I make a sports schedule

Hi,

Try Googling "sports schedule in Excel" or "creating a sports schedule in
Excel"


--
Thanks,
Shane Devenshire


"SHOETAC" wrote:

i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE

  #4   Report Post  
Old November 24th 09, 02:20 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2009
Posts: 1
Default sports scheduler

Hi, were you able to create a sports schedule in Excel? I'm doing the same thing but each team plays each other twice. I found a macro that will pair up the teams, but I can't seem to find a solution to schedule them randomly. thanks



SHOETA wrote:

how do I make a sports schedule
16-Oct-08

i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE

Previous Posts In This Thread:

On Thursday, October 16, 2008 5:39 PM
SHOETA wrote:

how do I make a sports schedule
i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE

On Friday, October 17, 2008 5:12 AM
Stef wrote:

how do I make a sports schedule
You gave not very much details, but if you have a list of teams in A2:A? then
this macro creates a combination of opponents for each team, then you can put
dates of matches in cells B1, C1, etc.


Sub sched()
Dim teams As Range, t As Range, e As Range
Noofteams = Range("A" & Rows.Count).End(xlUp).Row
Set teams = Range("A2:A" & Noofteams)
For Each t In teams
nexte = 0
For Each e In teams
If t < e Then
nexte = nexte + 1
Cells(t.Row, nexte + 1).Value = e.Value
End If
Next e
Next t
End Sub


Regards,
Stefi

???SHOETAC??? ezt ??rta:

On Friday, October 17, 2008 11:26 PM
ShaneDevenshir wrote:

Hi,Try Googling "sports schedule in Excel" or "creating a sports schedule in
Hi,

Try Googling "sports schedule in Excel" or "creating a sports schedule in
Excel"


--
Thanks,
Shane Devenshire


"SHOETAC" wrote:

EggHeadCafe - Software Developer Portal of Choice
Build a SAPI Text to Wav Converter Library
http://www.eggheadcafe.com/tutorials...xt-to-wav.aspx


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to make a weekend schedule without duplication of names Margaret Excel Discussion (Misc queries) 1 July 16th 07 07:50 PM
How do I make a sports league table in Excel donkamero Excel Discussion (Misc queries) 1 July 17th 06 04:45 AM
How can I make a schedule using Excel? [email protected] Excel Discussion (Misc queries) 0 January 16th 06 05:05 AM
How to make a schedule [email protected] Excel Discussion (Misc queries) 2 January 16th 06 12:00 AM
How do I make a Schedule Appointment for personal meeting Ashleyt New Users to Excel 1 July 2nd 05 01:15 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017