Invoices from CSV File

Hey team
I need to create an overview of each Club, the teams registered under each club, also the independent clubs.
I would like a total game count for the season, then a breakdown of the game count for each club/grade/team/independent.

I am aiming to invoice each club for all teams registered plus the total number of games each team will play, under each grade etc.

Please let me know if you have any questions.

Thank you very much, in advance for you help!!

2024.03.21 - Full Fixtures Autumn 2024.xlsx

I think Pivot Table could very helpful to achieve what you want. I created 2 PT for you with Slicers to help filtering.

Same as DJ, using slicers and PivotTables.

Thanks Team!!

This is amazing. 3 fantastic options. I can't thank you enough.

Hi @SBA-Sabres Just handle it according to the following method

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.

thank you. I was aware of the reputation and have definitely done that.
I wasn't aware about the solved button.

Hi SBA-Sabres You did a great job, warmly welcome to the forum

Tks for the feedback, glad to have helped.