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
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.

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

      I have no idea why this forum has such issues and have complained about it also.  In fact I hope you don't mind that I screenshot this thread and added it to my complaint in the Tech community discussion hub.

      On another note, how can I help?  If you want to PM me instead that is fine.

Resources