-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
league
-
F
Pub pool tournament and league table.
Hi, I am trying to create a weekly knockout tournament and a subsequent league table based on the results on KingSoft Spreadsheets, I know this is not excel but it's as close as. The Issue I'm having is connecting a team name/number to it's relevant league points, can enter it manually as...- Fabienw1991
- Thread
- league tournament
- Replies: 0
- Forum: Excel Questions
-
F
Random Team Scheduler Over Multiple Weeks
<body> <p>Hi All,</p><p>I need help trying to make a team scheduler for a non-profit league using XL2003/7. I need to pick random opponents over an 8 week period for each team with no team playing each other more than once, and only playing one game each week. The number of teams can vary...- foxhound
- Thread
- league random schedule sports teams
- Replies: 1
- Forum: Excel Questions
-
V
Excel League Rankings
I am trying to rank these teams in order of points, then goal difference and then goals scored, but I don't know the formula, I used to use a formula with rank and sumproduct, but I have forgotten it. I will attach a spreadsheet I compiled in Office 2010 x64 As soon as I know how to add...- VBAX
- Thread
- formula league rank sumproduct
- Replies: 15
- Forum: Excel Questions
-
A
Excel for Football National League
in bellow table, assume that "A" to "R" in c and d columns are 18 club's names of a national league. <table width="467" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col...- aminexcel
- Thread
- clubs excel footbal league ranking
- Replies: 1
- Forum: Excel Questions
-
S
Badminton Tournement League
I have been asked to run a one day Badminton Tournament 8 players against each other. What functions could best do the job of recording the results and transferring them to a league table that can show real time player’s positions.- shagsby
- Thread
- fixtures league results sport tables
- Replies: 2
- Forum: Excel Questions
-
M
cant work out this formula
<TABLE style="WIDTH: 710pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=942><COLGROUP><COL style="WIDTH: 172pt; mso-width-source: userset; mso-width-alt: 8374" width=229><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH...- murdock
- Thread
- arrows league position characters
- Replies: 2
- Forum: Excel Questions
-
I
Secondary sort of League Tables
Am trying to put some league tables together for a local amateur football group. Would appreciate help where a secondary sort is required to separate teams tied on points. Goal difference is the tie breaker. Rank and Vlookup is what I've been using for the original sort but how do I then...- Ivanhoe306
- Thread
- league sort array table vlookup and if
- Replies: 3
- Forum: Excel Questions
-
S
League Table
Hi Guys & Gals, I am trying to create a staff league table. They get points for shifts worked, Revenue Taken, Items Sold, And Perecentage of overal sales. I would like this to run over a year and update when we add or paste data from different dates into it. Can someone...- Sykovampyr
- Thread
- automatically fourmulas league table
- Replies: 0
- Forum: Excel Questions
-
M
Sorting a list automatically by changing details...?
Hi people, I have just recently managed to create a quiet sensible football league table where the table gets generated automatically by entering the results of the matches between the teams. What I need is whether it is possible to sort the table automatically after filling in some results of...- muffingg
- Thread
- creating football league sorting table
- Replies: 2
- Forum: Excel Questions
-
D
League table help
Hi, firstly I would like to apologise for possibly not using the correct terminology, but will try and explain this as best as possible. I am trying to create a "league table" kind of chart that will record the wins/losses/points etc of the members of the league. It will be used to monitor...- Daneshi
- Thread
- excel league macro
- Replies: 2
- Forum: Excel Questions
