Re: Grading & Excel-dropping 1

[Vern Lindberg <vwlsps@ritvax.isc.rit.edu>]

Martha Takats writes
> The best n-1 of n is easy: just use sum()-min() where the parentheses
> contain the range (you have to fill in zero's if there are any
> missed assignments).

The following eliminates the need for filling in zeros

Student    5  6  3  7     9  4

Possible  10 10 10 10 10 10 10

IF(COUNT(student range)=COUNT(possible range), SUM(...) - MIN(...), SUM(...))

This drops the lowest grade only if the count of student assignments
matches the count of possible assignmnets.

The more general problem is tough, since Excel seems to allow soprting by
column values only, and not by rows.  The accounting spreadsheet bias again.

Vern