Help- Sort data to cumulative and then create pareto chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2734800%22%20slang%3D%22en-US%22%3EHelp-%20Sort%20data%20to%20cumulative%20and%20then%20create%20pareto%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734800%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20me%20with%20the%20following%3F%3C%2FP%3E%3CP%3EI%20need%20to%20sort%20the%20results%20cumulatively%2C%20so%20i%20can%20create%20a%20pareto%20chart%26nbsp%3B%20in%20excel%20for%20an%20assessment.%3C%2FP%3E%3CTABLE%20width%3D%22821%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2294%22%3EStudent%20ID%3C%2FTD%3E%3CTD%20width%3D%2285%22%3EFamily%20Name%3C%2FTD%3E%3CTD%20width%3D%2281%22%3EGiven%20Name%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EBiology%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EComputing%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EChemistry%3C%2FTD%3E%3CTD%20width%3D%2290%22%3EEnglish%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EMaths%3C%2FTD%3E%3CTD%20width%3D%2296%22%3EPhysics%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EFrench%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E84456%3C%2FTD%3E%3CTD%3EMostead%3C%2FTD%3E%3CTD%3EDesmond%3C%2FTD%3E%3CTD%3E81%3C%2FTD%3E%3CTD%3E67%3C%2FTD%3E%3CTD%3E54%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E91%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E85889%3C%2FTD%3E%3CTD%3ETowers%3C%2FTD%3E%3CTD%3EBelinda%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E81%3C%2FTD%3E%3CTD%3E67%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3E77%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E89442%3C%2FTD%3E%3CTD%3EMortimer%3C%2FTD%3E%3CTD%3EIan%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E56%3C%2FTD%3E%3CTD%3E55%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E91233%3C%2FTD%3E%3CTD%3EJobson%3C%2FTD%3E%3CTD%3EChris%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3E74%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E94332%3C%2FTD%3E%3CTD%3EHarris%3C%2FTD%3E%3CTD%3EJohn%3C%2FTD%3E%3CTD%3E95%3C%2FTD%3E%3CTD%3E82%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E97%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E94511%3C%2FTD%3E%3CTD%3EKay%3C%2FTD%3E%3CTD%3EOwen%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E74%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E81%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E94866%3C%2FTD%3E%3CTD%3EMatthews%3C%2FTD%3E%3CTD%3ELionel%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E63%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E62%3C%2FTD%3E%3CTD%3E54%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E96723%3C%2FTD%3E%3CTD%3EJohnson%3C%2FTD%3E%3CTD%3EPhilip%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E77%3C%2FTD%3E%3CTD%3E69%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E54%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E96909%3C%2FTD%3E%3CTD%3ECammell%3C%2FTD%3E%3CTD%3EMary%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E52%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E97702%3C%2FTD%3E%3CTD%3EAdams%3C%2FTD%3E%3CTD%3ESharleen%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E78%3C%2FTD%3E%3CTD%3E69%3C%2FTD%3E%3CTD%3E91%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E87%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2734800%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-2736002%22%20slang%3D%22en-US%22%3ERe%3A%20Help-%20Sort%20data%20to%20cumulative%20and%20then%20create%20pareto%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736002%22%20slang%3D%22en-US%22%3EIf%20those%20are%20real%20names--as%20they%20appear%20to%20be--you%20need%20to%20delete%20the%20post.%3CBR%20%2F%3ESecond%2C%20after%20you%20come%20back%20with%20an%20anonymous%20example%3A%20what%20do%20you%20mean%20by%20%22sort%20the%20results%20cumulatively%22%3F%20Total%20the%20various%20scores%2Fgrades%20and%20sort%20on%20that%20basis%3F%20Something%20else%3F%3C%2FLINGO-BODY%3E
New Contributor

Hi

Can someone please help me with the following?

I need to sort the results cumulatively, so i can create a pareto chart  in excel for an assessment.

<Chart Removed due to PII>

3 Replies

Deleted

Thanks for your reply Mathetes!
This is actually an assessment for a course and ‘the names as they appear to be’ are fictitious, they’re not real. So calm your farm. I find your response quite passive aggressive, patronising and unnecessary.
In the meantime, we’ve worked it out. Thanks.
PS How do I delete the post?

@Ky_182 

 

Please forgive me. I used to be a manager of HR data for a corporation, and am particularly sensitive to unintentional compromises of privacy; it happens here on this site more than you might believe. You did such a good job of rendering fictitious names I just assumed they were real and wanted to warn you.

 

On the questions, I really meant them as further clarification of what you were trying to do. 

Glad you solved it elsewhere.

 

And finally it turns out that the best you can do is edit a prior posting; it IS possible to delete a posted file, but a comment can only be edited....as I did with the one that so offended you. Thank you for speaking up to let me know how my tone came across. I'll be more careful in the future.