I assume that it may be possible for two Quizzers to have the same score so
you will have to ensure that no two score are exactly the same. The easiest
way of doing that is to enter in AB12:AB28, (or some other column if you are
already using that one), =AA12+ROW()/100000 and copy down to AB28 then hide
Column AB

B42 enter the formula:

=INDEX($A$12:$A$28,MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0))

Any tied scores will be listed in list order.

The results will list the Quizzers in nlist order untill enries are made in
AA12:AA28. If you want them to be blank untill all scores are entered the
enclose the formula in an IF() statement:

=IF(COUNT($AA$12:$AA$28)<17,"",INDEX($A$12:$A$28, MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0)))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"damanwitdaplan" wrote in message
...
Thank you so much for your help!

But now I have yet another problem that has similar results.

I need the individual results too. So right now I have.

In A12 "Quizzer #1" and the results (points) of that quizzer in AA12.
In A13 "Quizzer #2" and the results of that quizzer in AA13.
In A14 "Quizzer #3" and the results of that quizzer in AA14
In A24 "Quizzer #4" and the results of that quizzer in AA24
In A25 "Quizzer #5" and the results of that quizzer in AA25
In A26 "Quizzer #6" and the results of that quizzer in AA26
In A 27 "Quizzer #7, and the results of that quizzer in AA27
In A28 "Quizzer #8" and the results of that quizzer in AA28

Results
B42
B43
B44
B45
B46
B47
B48
B49

In C42 I have the following formula
=MAX(AA12:AB14,AA24:AB28)

In C43 I have
=LARGE((AA12:AB14,AA24:AB28),2)

In C44 I have
=LARGE((AA12:AB14,AA24:AB28),3)

And so on and so on. But I need the quizzer's name (in text) with the
highest number of points to be displayed in B42. In other words.

Results
B C
42 Quizzer #4 145 points
43 Quizzer #2 70 points
44 Quizzer #7 55 points

And so on.

In other words, I have the C column figured out but I just need help with
the B column. Can anybody help me?