Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to throw out the 2 lowest scores?
I would like to enter 8 quiz grades throw out the two lowest scores and get
the average of the 6 remaining scores. I know there's got to be a way to do this, I just haven't figured it out yet. Any help would be appreciated I am using Excel 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to throw out the 2 lowest scores?
Try this:
For scores in A1:H1 I1: =AVERAGE(LARGE(A1:H1,{1,2,3,4,5,6})) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rineay" wrote: I would like to enter 8 quiz grades throw out the two lowest scores and get the average of the 6 remaining scores. I know there's got to be a way to do this, I just haven't figured it out yet. Any help would be appreciated I am using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
Is it possible? | Excel Worksheet Functions | |||
Formula for displaying in 1 cell Lowest value from multiple other cells | Excel Worksheet Functions | |||
Does anyone know this formula ? lowest value shows in a cell | Excel Discussion (Misc queries) | |||
Formula for displaying the lowest number of a range? | Excel Worksheet Functions |