In Micrcosoft Excel....

MarkyP05 | 15:05 Thu 30th Mar 2006 | Technology

4 Answers

basically ive constructed a little spreadsheet for my essay and coursework marks for my uni work.

ive come out with final marks for 8 different modules. obviously given in 8 different boxes, thing is our degree is calculated on the best 7 (drop the lowest mark)

Is there a formula that i could use that will drop the lowest mark and give an average of the remaining 7?

Cheers

old mobile not working with new sim

LP's to CD's 30/3/06

Answers

1 to 4 of 4

Best Answer

No best answer has yet been selected by MarkyP05. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Machecoul

=((SUM(B2:B9)-LARGE(B2:B9,8)))/7

This did it for me!

I put my numbers in the cells B2 to B9. The LARGE function has been told which cells to look at (namely B2 to B9) and then find the 8th largest - i.e. the smallest. It was then all divided by 7.

For some reason I couldn't get the Average function to do it but as it is always 7 it shouldn't matter.

MarkyP05

Question Author

Works a treat, cheers!

Machecoul

You can also replace the LARGE function with SMALL

so it would be -SMALL(B2:B9,1) this would give the smallest value in the range .... which is what you want.

I found this out by having a look at the INSERT menu and selecting FUNCTION and having a look at some of the FUNCTION descriptions. Amazing what you find.

-- answer removed --

1 to 4 of 4

Do you know the answer?