Building an Excel document for a competition. I have 3 worksheets.
Sheet 1 - individual scores in each team with an overall team score.
Sheet 2 - Team Score League Table
Sheet 3 - Individual Score League Table
In Sheet 2 I have ranked teams score (team order - they are numbered 1 - 20) and want any two teams or more can score the same amount and be ranked the same as well using the team score from Sheet 1.
How can I now use this data to rank the teams in score order and highlight any that have the same score (for ease of viewing)?
In Sheet 3 I have ranked the individual's score (individual order) and want any two individuals or more can have the same score and be ranked the same as well using the individual score from Sheet 1.
I want to rank the individual scores like the team scores in order of their score and automatically highlight any individuals with the same score (again, for ease of viewing)?
Please help!!!
Sheet 1 - individual scores in each team with an overall team score.
Sheet 2 - Team Score League Table
Sheet 3 - Individual Score League Table
In Sheet 2 I have ranked teams score (team order - they are numbered 1 - 20) and want any two teams or more can score the same amount and be ranked the same as well using the team score from Sheet 1.
How can I now use this data to rank the teams in score order and highlight any that have the same score (for ease of viewing)?
In Sheet 3 I have ranked the individual's score (individual order) and want any two individuals or more can have the same score and be ranked the same as well using the individual score from Sheet 1.
I want to rank the individual scores like the team scores in order of their score and automatically highlight any individuals with the same score (again, for ease of viewing)?
Please help!!!