My friends and I decided to make a small board game tournament amongst ourselves for fun. I decided to make an Excel sheet to help with keeping score and having a table, league standing, point system, and more.
I am stuck since I decided to make various tables with the headers being "Position (this being 1st, 2nd, 3rd, and so on)", "Player", and "Points" that they received on that specific day. We made it so that depending on your standing at the end of the match that day, you will gain a certain amount of points from your position, just like F1.
I then made a separate worksheet that is a copy of the table above that I can use to get data since I will be sorting the first table to update based on current player points.
I am stuck since I do not know how to add the different points based on the placement of every player in every match. I can't attach pictures so if you need them I can email them. I appreciate any help. Thanks.