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
Highlighted
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
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies