GarryFalcon
New Member
- Joined
- Jan 30, 2019
- Messages
- 1
Hi,
Please take a look at the image I linked below pertaining to my question.
http://i.imgur.com/OagzyfM.png
The above image is a spreadsheet keeping score of a sport league. The games are played on different dates and there are different players coming to different games (some players come on multiples games). The final standings are manually reported every time on columns B and C, with the points being awarded based on a formula (column D).
There’s a table of all time points (column G to I) keeping all the points of all the players that they earned.
My question is how to autofill column H, where the names of all the players that have played in the league will appear, based on the player names recorded on column B. Of course, the names on column H needs to be unique text values (no duplicate names from column B).
Whenever I reported a score for a bracket in column B to D, if it’s the same player, column I will automatically add the new points to the all time table (I can achieve this with a SUMIF formula). If there’s a new player that is recorded on column B (has never appeared in column H before), I want to have a new cell in column H automatically fill in his name (this is the part I don’t know how to do). At the moment I have the all time table example in the above image typed in manually.
Bonus question: I want the all time table to always sort itself in descending order based on the highest score earned, and the standing (column G) to update automatically.
Thanks in advance for taking a look at my question and helping me.
[Excel Sheet Example](https://imgur.com/gallery/bTIpSoy)
Please take a look at the image I linked below pertaining to my question.
http://i.imgur.com/OagzyfM.png
The above image is a spreadsheet keeping score of a sport league. The games are played on different dates and there are different players coming to different games (some players come on multiples games). The final standings are manually reported every time on columns B and C, with the points being awarded based on a formula (column D).
There’s a table of all time points (column G to I) keeping all the points of all the players that they earned.
My question is how to autofill column H, where the names of all the players that have played in the league will appear, based on the player names recorded on column B. Of course, the names on column H needs to be unique text values (no duplicate names from column B).
Whenever I reported a score for a bracket in column B to D, if it’s the same player, column I will automatically add the new points to the all time table (I can achieve this with a SUMIF formula). If there’s a new player that is recorded on column B (has never appeared in column H before), I want to have a new cell in column H automatically fill in his name (this is the part I don’t know how to do). At the moment I have the all time table example in the above image typed in manually.
Bonus question: I want the all time table to always sort itself in descending order based on the highest score earned, and the standing (column G) to update automatically.
Thanks in advance for taking a look at my question and helping me.
[Excel Sheet Example](https://imgur.com/gallery/bTIpSoy)
