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

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel as a gradebook with ability to drop lowest grade 3
How to highlight the lowest valued cell in a column in Excel 2003 2
Excel 2007 - Cannot Delete or Insert Rows 1
How to find lowest value in row 1
Assigning values to a variable set 1
How do I find the position of the lowest value in a row? 2
how do i find the lowest number in a column in Excel? 4
print first two rows (heading) and one row per page... 1

Top