Hey gang,

I need help with the following problem. I have a worksheet that lists names
in colA, averages in colB, and scores in colC.

I'd like to be able to show the high scores in a different section on the
worksheet. I can use MAX function to locate the largest number (score, avg)
but how do I get the name associated with it? Also, how can I show the 2nd
and 3rd largest scores or averages? Will I have to use a different function
than MAX (such as LARGE)??

Thanks again for all the help!
Matt

=LARGE(B2:B100,1)
first largest
=LARGE(B2:B100,2)
second largest
To get the name associate with it
=INDEX(A2:A100,MATCH(LARGE(B2:B100,1),B2:B100,0))

Adjust your range to suit your needs


"mpenkala" wrote:

Hey gang,

I need help with the following problem. I have a worksheet that lists names
in colA, averages in colB, and scores in colC.

I'd like to be able to show the high scores in a different section on the
worksheet. I can use MAX function to locate the largest number (score, avg)
but how do I get the name associated with it? Also, how can I show the 2nd
and 3rd largest scores or averages? Will I have to use a different function
than MAX (such as LARGE)??

Thanks again for all the help!
Matt

Hi there,

I can't seem to get the formula to work. This is what I have:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1)B 2:B28,0))

Excel keeps trying to put a * before the 2nd B2 near the end. If this helps:
A2:A28 are a list of names
B2:B28 is a list of scores

In cell A42 I have the high score. I would like cell A41 to give me the
name associated with that score.

Any ideas? Thanks for the help.

Matt



"Teethless mama" wrote:

=LARGE(B2:B100,1)
first largest
=LARGE(B2:B100,2)
second largest
To get the name associate with it
=INDEX(A2:A100,MATCH(LARGE(B2:B100,1),B2:B100,0))

Adjust your range to suit your needs


"mpenkala" wrote:

Hey gang,

I need help with the following problem. I have a worksheet that lists names
in colA, averages in colB, and scores in colC.

I'd like to be able to show the high scores in a different section on the
worksheet. I can use MAX function to locate the largest number (score, avg)
but how do I get the name associated with it? Also, how can I show the 2nd
and 3rd largest scores or averages? Will I have to use a different function
than MAX (such as LARGE)??

Thanks again for all the help!
Matt

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1)B 2:B28,0))
Excel keeps trying to put a * before the 2nd B2 near the end.

You're missing a comma and the sheet name:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1), Sheet2!B2:B28,0))

If there are duplicates this won't work properly!

Biff

"mpenkala" wrote in message
...
Hi there,

I can't seem to get the formula to work. This is what I have:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1)B 2:B28,0))

Excel keeps trying to put a * before the 2nd B2 near the end. If this
helps:
A2:A28 are a list of names
B2:B28 is a list of scores

In cell A42 I have the high score. I would like cell A41 to give me the
name associated with that score.

Any ideas? Thanks for the help.

Matt



"Teethless mama" wrote:

=LARGE(B2:B100,1)
first largest
=LARGE(B2:B100,2)
second largest
To get the name associate with it
=INDEX(A2:A100,MATCH(LARGE(B2:B100,1),B2:B100,0))

Adjust your range to suit your needs


"mpenkala" wrote:

Hey gang,

I need help with the following problem. I have a worksheet that lists
names
in colA, averages in colB, and scores in colC.

I'd like to be able to show the high scores in a different section on
the
worksheet. I can use MAX function to locate the largest number (score,
avg)
but how do I get the name associated with it? Also, how can I show the
2nd
and 3rd largest scores or averages? Will I have to use a different
function
than MAX (such as LARGE)??

Thanks again for all the help!
Matt

Hey again,

Thanks Biff. The comma was what I was missing. Everything is working
perfect!

Thanks again,
Matt


"T. Valko" wrote:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1)B 2:B28,0))
Excel keeps trying to put a * before the 2nd B2 near the end.

You're missing a comma and the sheet name:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1), Sheet2!B2:B28,0))

If there are duplicates this won't work properly!

Biff

"mpenkala" wrote in message
...
Hi there,

I can't seem to get the formula to work. This is what I have:

=INDEX(Sheet2!A2:A28,MATCH(LARGE(Sheet2!B2:B28,1)B 2:B28,0))

Excel keeps trying to put a * before the 2nd B2 near the end. If this
helps:
A2:A28 are a list of names
B2:B28 is a list of scores

In cell A42 I have the high score. I would like cell A41 to give me the
name associated with that score.

Any ideas? Thanks for the help.

Matt



"Teethless mama" wrote:

=LARGE(B2:B100,1)
first largest
=LARGE(B2:B100,2)
second largest
To get the name associate with it
=INDEX(A2:A100,MATCH(LARGE(B2:B100,1),B2:B100,0))

Adjust your range to suit your needs


"mpenkala" wrote:

Hey gang,

I need help with the following problem. I have a worksheet that lists
names
in colA, averages in colB, and scores in colC.

I'd like to be able to show the high scores in a different section on
the
worksheet. I can use MAX function to locate the largest number (score,
avg)
but how do I get the name associated with it? Also, how can I show the
2nd
and 3rd largest scores or averages? Will I have to use a different
function
than MAX (such as LARGE)??

Thanks again for all the help!
Matt