ExcellingAtLife
New Member
- Joined
- Jun 26, 2024
- Messages
- 1
- Office Version
- Prefer Not To Say
- Platform
- Windows
Hi guys,
One of our admin is currently calculating exam marks manually, and with over 200 to calculate I've offered to help. However, I've hit a blank...
We host an exam series with two types of exam and the student final scores are their highest three scores BUT one score must come from exam type A and one score from exam type B (I didn't realise this and just started using the LARGE function to SUM the three highest scores across all 6 exams which was incorrect).
I'm stumped, I started trying using LARGE and just selecting the cells with exam scores for type A to find the highest score for type A, then repeating for B, but then I can't get my head around the next step because technically all three highest scores could some from one exam type, and plus some students have only attended exam type A, missing type B (or vice versa), so shouldn't have an overall score as they've failed by default... Help!
Below is an idea of what the spreadsheet looks like (obvs anonymised) to give you an idea of what it looks like![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
One of our admin is currently calculating exam marks manually, and with over 200 to calculate I've offered to help. However, I've hit a blank...
We host an exam series with two types of exam and the student final scores are their highest three scores BUT one score must come from exam type A and one score from exam type B (I didn't realise this and just started using the LARGE function to SUM the three highest scores across all 6 exams which was incorrect).
I'm stumped, I started trying using LARGE and just selecting the cells with exam scores for type A to find the highest score for type A, then repeating for B, but then I can't get my head around the next step because technically all three highest scores could some from one exam type, and plus some students have only attended exam type A, missing type B (or vice versa), so shouldn't have an overall score as they've failed by default... Help!
Below is an idea of what the spreadsheet looks like (obvs anonymised) to give you an idea of what it looks like