Golf competition - matrix of games played and results from MS Form
This is the second question relating to this problem.
I am administrating a golf competition which is played on the basis of one v one, holes won and 3 points for a win, 0 points for a loss and 1 point for a draw.
Results are being collected via an MS Form to an Excel file. The collected data looks like the image (names redacted). Each player could appear in the Player 1 or Player 2 column. This data is just mock data to check the form is working. The player submits all the data, including the Points, that is, the Points are not based upon the Holes won data submitted by the form.
I now have the League Table set up however the organiser has asked if I can also provide a matrix showing which matches are complete, and if possible, the result for each match. Something like the following.
How would I analyse the data from the MS Form to create such a matrix?
[link] [comments]
Want to read more?
Check out the full article on the original site