Remember Me?

#1
August 12th 05, 12:12 PM
 Teacher Posts: n/a

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.

#2
August 12th 05, 12:59 PM
 StinkeyPete Posts: n/a

Try this:

=(SUM(B2:F2)-(MIN(B2:F2)))/(COUNT(B2:F2)-1)

This will drop the lowest grade and give you the average grade after the
lowest grade is dropped. This assumes that you have five grades entered in
columns B through F.

Hope this helps.

"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.

#3
August 12th 05, 01:35 PM
 Domenic Posts: n/a

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.

#4
August 17th 05, 11:38 AM
 Teacher Posts: n/a

Thanks so much, Domenic and Pete! I'll try those!!!

"Domenic" wrote:

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Bren Excel Worksheet Functions 3 June 23rd 05 12:13 AM Create a calendar drop down box Excel Discussion (Misc queries) 1 April 28th 05 04:00 PM Phlashh Excel Discussion (Misc queries) 1 January 11th 05 09:56 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM lalewis Excel Discussion (Misc queries) 1 January 5th 05 04:29 AM

All times are GMT +1. The time now is 09:48 PM.