View original (French)

Excel find the name of the major student

chellynacim79 Posted messages 1 Status Member -  
Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   -
Bonsoir,
Can you help me find the Excel formula in C6 that returns the name of the top student?
Excel table:
A B C D E
1 Student Score1 Score2 Average Rank
2 S1 15 12 12.9 1
3 S2 5 9 7.8 4
4 S3 12 10 10.6 2
5 S4 11 9 9.6 3
6 Top Student ?

Thank you in advance

Configuration: Windows 7 / Safari 535.2

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello

    With one of these 2 formulas you should be able to do it: 

    =OFFSET($A$1,MATCH(1,$E:$E,0)-1,0) or =INDEX($A$2:$A$5,MATCH(MAX($D$2:$D$5),$D$2:$D$5,0))

    --

    Always zen
    0
  2. Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    To calculate the RANK in E2

    =RANK(D2,$D$2:$D$9) and then drag down

    to display the name of the top student from column A, either put 1 the rank number, for example in F2
    =INDEX(A2:D5,MATCH(F2,E2:E5,0),1)

    or you can insert the rank calculation into the formula

    =INDEX(A2:D9,MATCH(RANK(D2,$D$2:$D$9),E2:E9,0),1)

    however, if you have multiple top students, you will need to complete the formula; if that's the case, tomorrow morning it will be day

    --
    A+
    Mike-31

    A failure period is a perfect time to sow the seeds of knowledge.
    0