Score table with position and score
-
I need to make a table that contatins the following columns:
# Position (1, 2, 3, 4 etc.)
Name (Peter, Martin, Sue, Ellen, etc.)
Points (10, 5, 7, 3, etc.)Position is the persons place in the competition.
Name is the competitor.
Points is the persons score. This will change during the competition and is manually updated once a day.When I change a persons PONITS in the table I need the POSITION to change value as well. The person with the highest POINTS is number one and so on.
If for example Peter is number 1 and has 10 points and Martin is number 2 with 8 points this week. Then next week Martin wins and get an extra 3 POINTS. Now Martin has 11 POINTS and his POSITION needs to be changes to number 1 and Peters POSITION to numner 2.
Is that possible?
The topic ‘Score table with position and score’ is closed to new replies.