Mitchell Arthur
New Member
- Joined
- May 4, 2020
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Good Afternoon all,
Firstly, im not sure this is possible but its worth a shot!
I have a spreadsheet which has multiple rows of people and their exam score data. Each students final mark is their 3 highest scores however there is a certain combination of the scores required.
The combination has to be Highest Team Sports score + Highest Individual Sports score + Next highest team OR individual sports score. I have attached a simple picture below for reference.
Persons A score should total 25 and Persons B score should total 30.
Due to the depth of my real spreadsheet which holds data for over 150 students if this score was generated automatically every time scores got updated my life would be much much easier!
If anyone can help, i will forever be in your debt!
Many Thanks
Mitchell
Firstly, im not sure this is possible but its worth a shot!
I have a spreadsheet which has multiple rows of people and their exam score data. Each students final mark is their 3 highest scores however there is a certain combination of the scores required.
The combination has to be Highest Team Sports score + Highest Individual Sports score + Next highest team OR individual sports score. I have attached a simple picture below for reference.
Persons A score should total 25 and Persons B score should total 30.
Due to the depth of my real spreadsheet which holds data for over 150 students if this score was generated automatically every time scores got updated my life would be much much easier!
If anyone can help, i will forever be in your debt!
Many Thanks
Mitchell