Jun 07 2019 12:08 AM
Hi all, I'm hoping somebody can help with this?
I need an average score for each person, in each of the different divsions they compete in
Sample table below
Player 1 when competing in yellow division = what is their average score?
Player 1 when competing in green division = what is their average score?
Player 2 when competing in yellow division = what is their average score? and so on
I have a huge excel spreadsheet, how do I do this quickly?
Full_Name Division Score
Player 1 Yellow 30.00%
Player 1 Yellow 40.00%
Player 1 Yellow 70.00%
Player 1 Green 16.00%
Player 1 Green 20.00%
Player 1 Green 15.00%
Player 2 Yellow 15.00%
Player 2 Yellow 70.00%
Player 2 Yellow 25.00%
Player 2 Blue 100.00%
Player 2 Blue 91.00%
Player 2 Blue 92.00%
Jun 07 2019 12:21 AM
Solution
Hi,
The easiest and quickest way to do that is by using the PivotTables as follows:
Regards,
Haytham
Jun 13 2019 05:31 PM - edited Jun 13 2019 05:32 PM
Thank you, perfect !!
Jun 07 2019 12:21 AM
Solution
Hi,
The easiest and quickest way to do that is by using the PivotTables as follows:
Regards,
Haytham