Hi guys,
Need help with the attached excel file.
Its related to a game. There are 10 players numbered 1 to 10 and at each round (labelled r1 r2 etc.) they get points as populated in the file.
What I need is: I would like to identify the player with the highest score at each round (cells d14 - e16). But I do not want to have additional columns to calculate the cumulative score at each round for each player (like column J onwards).
Is there a way I can do this ?
one way see array functions in yellow cells
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
You could :-
=MATCH(MAX(D2:D11),D2:D11,0)
=SUMPRODUCT(MATCH(MAX(D2:D11+E2:E11),D2:D11+E2:E11,0))
=SUMPRODUCT(MATCH(MAX(D2:D11+E2:E11+F2:F11),D2:D11+E2:E11+F2:F11,0))
=SUMPRODUCT(MATCH(MAX(D2:D11+E2:E11+F2:F11+G2:G11),D2:D11+E2:E11+F2:F11+G2:G11,0))
=SUMPRODUCT(MATCH(MAX(D2:D11+E2:E11+F2:F11+G2:G11+H2:H11),D2:D11+E2:E11+F2:F11+G2:G11+H2:H11,0))
in cells e14 to e18
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks