Forum Discussion

Neil Frudd's avatar
Neil Frudd
Copper Contributor
Jun 05, 2018

A Range

Hi, I am currently reviewing and scoring applications for a job. So I now have a total score for each applicant (15) in one column. How do I arrange the scores into an order in an adjacent column so I can easily see who I should be interviewing? Does this make sense ?
Formulas & Functions
Need Help

2 Replies

  • Arul Tresoldi's avatar
    Arul Tresoldi
    Iron Contributor
    Jun 05, 2018
    Do you mean the Rank function?
    =RANK(score;all scores preferably locked with $)

    For example in A2 cell:
    =RANK(C2;$C$2:$C$17)
    This shows the ranking of the score (in C2) compared to all scores (from C2 to C17); let's say in B there is the name and in A you want to see the ranks.

    1 Robert 15
    3 Francis 10
    2 Joseph 12

    If you want the opposite order, you change the formula to
    =RANK(C2;$C$2:$C$17;1)