How to find the lowest number of a row and delete it automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tryint to help a teacher with her gradebook and she wants to be able to
delete the lowest score of each student automatically (they are arranged in
rows) for grading purposes. (she drops the lowest grade). Is there a way to
have excel do this for us?
 
Instead of deleting the data, it might be better to have the formula just ignore
that lowest value. If she's averaging the scores:

=(sum(b2:j2)-min(b2:j2))/(count(b2:j2)-1)

It adds all the values in B2:J2, subtracts the lowest score
and divides by (the number of scores - 1)

If this doesn't help, you may want to share the formula she uses to get scores.
 
Back
Top