furi_07
New Member
- Joined
- Feb 16, 2021
- Messages
- 1
- Office Version
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- Mobile
- Web
Hi ,
Im creating a project where i want to store data of round robin tournament and i have 10 participants which we will play with each other over the period. i have a table where i store match data . and i want another table to show which matches are already played and which are pending for respective captain .
for reference im attaching screenshots of my sheet and desired output table which i want .
im ok with output like Done/pending , True/false, Match date (stored in sheet). match no (stored in same sheet)..
if you are referencing image , i want to fill any of the table and condition should be if captain 1 & captain 2 have faced each other already then it should show in either of table 2 or table 1 whichever is feasible
Im creating a project where i want to store data of round robin tournament and i have 10 participants which we will play with each other over the period. i have a table where i store match data . and i want another table to show which matches are already played and which are pending for respective captain .
for reference im attaching screenshots of my sheet and desired output table which i want .
im ok with output like Done/pending , True/false, Match date (stored in sheet). match no (stored in same sheet)..
if you are referencing image , i want to fill any of the table and condition should be if captain 1 & captain 2 have faced each other already then it should show in either of table 2 or table 1 whichever is feasible