god1mylove
New Member
Hey there,
We started a basketball themed game at our work that I need to create a spreadsheet for. It is very simple. Column "A" has each player from A4 to A20. Columns "B", "C", "D", "E", and "F" hold the score for each day for each member. And Column "G" has the total for the week. Just like basketball, there are four quarters, so each week is one quarter.
At the bottom of the spreadsheet I have cells for round 1, round 2, round 3, round 4, and winner. I would like to have the name of the player with the highest score for round 1, automatically enter into the "round 1" cell. For round 2 it will be the player with the highest combined score from round 1 and 2. And so on... until the winner.
Is there a way to do this?
We started a basketball themed game at our work that I need to create a spreadsheet for. It is very simple. Column "A" has each player from A4 to A20. Columns "B", "C", "D", "E", and "F" hold the score for each day for each member. And Column "G" has the total for the week. Just like basketball, there are four quarters, so each week is one quarter.
At the bottom of the spreadsheet I have cells for round 1, round 2, round 3, round 4, and winner. I would like to have the name of the player with the highest score for round 1, automatically enter into the "round 1" cell. For round 2 it will be the player with the highest combined score from round 1 and 2. And so on... until the winner.
Is there a way to do this?