Forum Discussion

ajriddin's avatar
ajriddin
Copper Contributor
Oct 24, 2023

Help with ranking

Good day I am in need of some help with a spreadsheet. The sheet serves the following purposes: 1) Show list of students and their results per subject. 2) Display the Top 10 learners per subject ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 24, 2023

ajriddin 

Since you have blanks give name to entire column starting from the second row, here R_Math1.

Larger score

=IFERROR( AGGREGATE(14,6, R_Math1/(R_Math1<>""), ROW() - ROW($E$17) ), "")

Surname

=IFNA( INDEX(R_Surname,MATCH(B18,R_Numbers,0)), "")

Name

=IFNA( INDEX(R_Name,MATCH(B18,R_Numbers,0)), "")

Gno

=IFERROR( INDEX(R_Numbers,MATCH(E18,R_Math1,0)), "")
  • ajriddin's avatar
    ajriddin
    Copper Contributor
    Oct 24, 2023
    Thank you!! When naming the entire column, must I do that for all the named ranges I have, or only for those that have marks?