View Single Post
  #3   Report Post  
Domenic
 
Posts: n/a
Default

Assuming that B2:F2 contains the test grades (5 for this example),
here's another way...

=AVERAGE(LARGE(B2:F2,{1,2,3,4}))

Hope this helps!

In article ,
"Teacher" wrote:

I use Excel as my gradebook using separate worksheets for subcategory. In the
test worksheet, I would like to be able to, for each student, drop the lowest
test grade. This may be a different test for each student.