Help Find The Top 5

[MADx]

I am running a contest at work were we have four teams made of 9 people. We track 6 different items for each person, my sheet then calculates there new total for each person. Off to the side I want to put a list of the top five people like below.

.............100........50......40......30......20......10......total
Stacey..................3........2......12................20.......790
Ryan....................5.................9..................7.......590


top five people
stacey <--------so fist I need to find the top score and then return the name
ryan <--------then I need to find the 2nd highest score and again return the name.


Thanks for any help

[Biff]

Hi!

If there are no ties then it's fairly straightforward:

Names in column A, Totals in column H.

=INDEX(A$2:A$10,MATCH(LARGE(H$2:H$10,ROWS($1:1)),H$2:H$10,0))

If there are ties then it's a little more complicated. Post back if that's
the case.

Biff

"MADx" <[email protected]> wrote in message
news:[email protected]...
>
> I am running a contest at work were we have four teams made of 9 people.
> We track 6 different items for each person, my sheet then calculates
> there new total for each person. Off to the side I want to put a list
> of the top five people like below.
>
> ............100........50......40......30......20......10......total
> Stacey..................3........2......12................20.......790
> Ryan....................5.................9..................7.......590
>
>
> _top_five_people_
> stacey <--------so fist I need to find the top score and then return
> the name
> ryan <--------then I need to find the 2nd highest score and again
> return the name.
>
>
> Thanks for any help
>
>
> --
> MADx
> ------------------------------------------------------------------------
> MADx's Profile:
> http://www.excelforum.com/member.php...o&userid=37687
> View this thread: http://www.excelforum.com/showthread...hreadid=572928
>

[Biff]

P.S.

Copy the formula down as needed.

Biff

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> If there are no ties then it's fairly straightforward:
>
> Names in column A, Totals in column H.
>
> =INDEX(A$2:A$10,MATCH(LARGE(H$2:H$10,ROWS($1:1)),H$2:H$10,0))
>
> If there are ties then it's a little more complicated. Post back if that's
> the case.
>
> Biff
>
> "MADx" <[email protected]> wrote in
> message news:[email protected]...
>>
>> I am running a contest at work were we have four teams made of 9 people.
>> We track 6 different items for each person, my sheet then calculates
>> there new total for each person. Off to the side I want to put a list
>> of the top five people like below.
>>
>> ............100........50......40......30......20......10......total
>> Stacey..................3........2......12................20.......790
>> Ryan....................5.................9..................7.......590
>>
>>
>> _top_five_people_
>> stacey <--------so fist I need to find the top score and then return
>> the name
>> ryan <--------then I need to find the 2nd highest score and again
>> return the name.
>>
>>
>> Thanks for any help
>>
>>
>> --
>> MADx
>> ------------------------------------------------------------------------
>> MADx's Profile:
>> http://www.excelforum.com/member.php...o&userid=37687
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=572928
>>
>
>