# Getting the best 8 out of 10

This is a discussion on Getting the best 8 out of 10 within the Excel Questions forums, part of the Question Forums category; I have a grades spreadsheet organized with the students in rows and the various grading components in columns. This term, ...

1. ## Getting the best 8 out of 10

I have a grades spreadsheet organized with the students in rows and the various grading components in columns. This term, I collected assignments randomly and gave surprise quizzes with the best 8 out of ten counting. It is easy to do the best 9 out of 10, but can anyone suggest a way to do the best 8 out of 10.

I'm Using Office 97

BTW, if this has been answered, my apologies. It was a difficult question to construct a search on.

Thanks.

2. Hi Alan Marshall:

Welcome to the Boare!

Please look at the following simulation ...

I have shown two methods : 1) by Sorting the Grades; 2) using an Array Formula

******** ******************** ************************************************************************>
 Microsoft Excel - y030409h1.xls ___Running: xl97 : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 F2F3F4F5F6F7F8F9 =

A
B
C
D
E
F
1
2
*95*95*95
3
*92*92*92
4
*92*92*92
5
*87*87*87
6
*87*87*87
7
*83*83*83
8
*78*78*78
9
*76*76*76
10
*76****
11
*69****
12
Sort*in*Descending*Order*and*then*pick
Top*10*values
**
13
**
 Sheet5 *

[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Does it hlp?

Edit: took the student name out in the simulation

3. ## Re: Getting the best 8 out of 10

I believe you want to average best 8 scores out of N = 9, 10...

******** ******************** ************************************************************************>
 Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 L2M2L3M3L4M4 =

A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
*Quizz1Quizz2Quizz3Quizz4Quizz5Quizz6Quizz7Quizz8Quizz9Quizz10NAvg*
2
Stud17020301004010090201001001078.8*
3
Stud220*7030103030604040940.0*
4
Stud37060807080607080**871.3*
5
**************
 Sheet1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

The formulas are...

L2:

=COUNT(B2:K2)

M2:

=IF(L2=8,AVERAGE(B2:K2),IF(L2>8,AVERAGE(LARGE(B2:K2,{1,2,3,4,5,6,7,8})),""))

4. Thank you!

I was not aware of the LARGE and SMALL functions.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•