9 Assessments but want the students 7 best results

F

Felicity

Ok I am putting together a results list for students and one of their
assessments has 9 components- the students need to see the results for all 9
assessments BUT the final grade is based on the best 7. Is there a way to
have all 9 assessments in excel and a final column with the sum of the best
7? Could someone please explain how to do this?

Thanks

Felicity
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to find out the grade from marks-functions 7
sum by rows in Pivot 1
Executing a formula based on criteria being met 2
Sort Columns of data at the same time, without regard to order. 3
Converting a letter grade to a numerical value 3
VBA Code to Use "Name" in a cell as a reference 1
Finding the weighted average of text that have been given values 1
How to find best and worst grade? 5

Top