Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the lowest number of a row and delete it automatically
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the lowest number of a row and delete it automatically
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. awinslow wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|