Sort & Rank Student Marks
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have raw score sheets for 60 students. Each sheet needs the marks of five subjects entered, the total for every student calculated, and the entire list reordered strictly by total marks so the highest scorer sits at the top and the lowest at the bottom.
Beyond the ranking, I also need two quick analytics passes: the average mark for each subject and a note of the single highest and lowest mark achieved in every subject. No charts, colour scales, or other visual touches are required—clean numbers are all I am after.
Deliverables
• A single Excel workbook containing one tidy sheet with all 60 records, subject scores, calculated totals, averages, and min/max figures.
• Clear, documented formulas so I can audit or reuse the file later.
A concise, formula-driven solution that avoids manual steps will be preferred.
Beyond the ranking, I also need two quick analytics passes: the average mark for each subject and a note of the single highest and lowest mark achieved in every subject. No charts, colour scales, or other visual touches are required—clean numbers are all I am after.
Deliverables
• A single Excel workbook containing one tidy sheet with all 60 records, subject scores, calculated totals, averages, and min/max figures.
• Clear, documented formulas so I can audit or reuse the file later.
A concise, formula-driven solution that avoids manual steps will be preferred.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.