Forum Discussion

TripleZ's avatar
TripleZ
Copper Contributor
Jun 28, 2025

Table tennis tournament

I want to organize a table tennis tournament. With ChatGPT I have made the following Excel document.   There will be 8 groups of 4 players. The top two players of the groups will advance to the nex...
excel
Formulas and Functions
  • TripleZ's avatar
    TripleZ
    Copper Contributor
    Jul 02, 2025

    I didn't see any change in the file, that I have uploaded. But thanks for uploading the file. I tried a couple of times to find the attachment, but I didn't see it.

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Jul 01, 2025

    I added a few things in this file.

    I added a "Teams" tab so insted of "Team 1" you can actually give each team a name (if you want)

    I updated all of the formulas to find the correct name based on the row instead of specifically specifying "Team 1" in the formula.

    I fixed the RANK formuals

    I reformatted the layout so it was 'cleaner' in my opinion

    I added a column for final group rank (I used SORTBY formula if that doesn't work for you let me know)

    I updated the format on the playoff tab to show the different stages better

    I updated the initial list of playoff teams to point to 1st and 2nd place teams

    • TripleZ's avatar
      TripleZ
      Copper Contributor
      Jul 04, 2025

      I have made a long reply to this message. I am not sure where it is has gone. It was awaiting moderation, but now I don't see my message anymore.

      • TripleZ's avatar
        TripleZ
        Copper Contributor
        Jul 08, 2025

        Before this message of 3 July 2025 I posted a long message. Can one of the moderators include that message in this discussion? It was an extensive reply to the person who helped me (m_tarler). In that message I asked for some edit in the Excel file he posted.

         

        I don't understand why messages are only being approved after a long period of 5 days.

Resources