• 549K Members
• 8,835 Online
• 657K Conversations
SOLVED

Highlighted
New Contributor

# Average for group of people in different divisions

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%

2 Replies
Solution

# Re: Average for group of people in different divisions

Hi,

The easiest and quickest way to do that is by using the PivotTables as follows:

Regards,

Haytham

Highlighted

# Re: Average for group of people in different divisions

Thank you, perfect !!

Related Conversations
People Web Part
LukeSplaz in SharePoint on
3 Replies
Outlook calendar vs Gmail Calendar
ConnectedGeek in SharePoint on
0 Replies