SOLVED
Home

Average for group of people in different divisions

%3CLINGO-SUB%20id%3D%22lingo-sub-676961%22%20slang%3D%22en-US%22%3EAverage%20for%20group%20of%20people%20in%20different%20divisions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676961%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I'm%20hoping%20somebody%20can%20help%20with%20this%3F%3C%2FP%3E%3CP%3EI%20need%20an%20average%20score%20for%20each%20person%2C%20in%20each%20of%26nbsp%3Bthe%20different%20divsions%20they%20compete%20in%3C%2FP%3E%3CP%3ESample%20table%20below%3C%2FP%3E%3CP%3EPlayer%201%26nbsp%3Bwhen%20competing%20in%20yellow%20division%20%3D%20what%20is%20their%20average%20score%3F%3C%2FP%3E%3CP%3EPlayer%201%26nbsp%3Bwhen%20competing%20in%26nbsp%3Bgreen%20division%20%3D%20what%20is%20their%20average%20score%3F%3C%2FP%3E%3CP%3EPlayer%26nbsp%3B2%26nbsp%3Bwhen%20competing%20in%20yellow%20division%20%3D%20what%20is%20their%20average%20score%3F%26nbsp%3B%20and%20so%20on%3C%2FP%3E%3CP%3EI%20have%20a%20huge%20excel%20spreadsheet%2C%20how%20do%20I%20do%20this%20quickly%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFull_Name%20Division%20Score%3CBR%20%2F%3EPlayer%201%20Yellow%2030.00%25%3CBR%20%2F%3EPlayer%201%20Yellow%2040.00%25%3CBR%20%2F%3EPlayer%201%20Yellow%2070.00%25%3CBR%20%2F%3EPlayer%201%20Green%2016.00%25%3CBR%20%2F%3EPlayer%201%20Green%2020.00%25%3CBR%20%2F%3EPlayer%201%20Green%2015.00%25%3CBR%20%2F%3EPlayer%202%20Yellow%2015.00%25%3CBR%20%2F%3EPlayer%202%20Yellow%2070.00%25%3CBR%20%2F%3EPlayer%202%20Yellow%2025.00%25%3CBR%20%2F%3EPlayer%202%20Blue%20100.00%25%3CBR%20%2F%3EPlayer%202%20Blue%2091.00%25%3CBR%20%2F%3EPlayer%202%20Blue%2092.00%25%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-676961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676984%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20for%20group%20of%20people%20in%20different%20divisions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356345%22%20target%3D%22_blank%22%3E%40mickeyc888_-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20easiest%20and%20quickest%20way%20to%20do%20that%20is%20by%20using%20the%20PivotTables%20as%20follows%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117433iD007E441DB505425%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Summarize%20Date%20By%20Average%20Using%20PivotTables.png%22%20title%3D%22Summarize%20Date%20By%20Average%20Using%20PivotTables.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691499%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20for%20group%20of%20people%20in%20different%20divisions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20perfect%20!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
mickeyc888_-
New Contributor

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
Highlighted
Solution

@mickeyc888_- 

 

Hi,

 

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

Summarize Date By Average Using PivotTables.png

 

 

Regards,

Haytham

@Haytham Amairah 

Thank you, perfect !!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies