league

  1. 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...
  2. 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...
  3. 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.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...

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
Back
Top