LinkBack URL
About LinkBacks
How to find first rank without adding list of ranks
Thank You
How to find first rank without adding list of ranks
Thank You
j2 = =MAX(C2:C11+D2:D11+E2:E11+F2:F11) array entered
i2 = =INDEX(B2:B11,MATCH(J2,INDEX(C2:C11+D2:D11+E2:E11+F2:F11,0),0)) array entered
match all tasks
=INDEX(B2:B11,MATCH("1111",INDEX(--(C2:C11<>"")&--(D2:D11<>"")&--(E2:E11<>"")&--(F2:F11<>""),0),0))
Last edited by martindwilson; 04-07-2013 at 12:39 PM.
"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
what is your concern about adding another helper column? It can always be hidden, and a helper will make both finding the name AND the rank simple.
a simple =SUM(C2:F2) in column G
then in J2 =LARGE(G2:G11,1)
and in I2 =INDEX($B$2:$G$11,MATCH(J2,$G$2:$G$11,0),1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thank you FDibbins,
About helper column, it is mostly no problem for me. At that time I had just got some data protected except unsufficient rows. Above all, you really helped...
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks