Creating a League Table from a series of match results
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 want to create a linked League Table (in a separate sheet) which automatically sums the points for each person and shuffles the order Z-A by total points. I'd also like to have games played and total Holes Won (this will be the deciding factor in the event of a draw in points).
Currently I have the Form linked table and a linked table using =OfficeForms.Table[#All] in a separate sheet.
I am not sure:
Which sheet I use to create the League (Form table or the linked table)
How to analyse and manipulate the data to create the League Table
I'd also like a conditional formatting option to cross check that the points allocated is correct
[link] [comments]
Want to read more?
Check out the full article on the original site