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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks