Ranking 2

[Harquor]

Hello there! I am using the formula below to rank (1 - 13) numbers from highest to lowest. How do I get it to rank (1 - 13) numbers from lowest to highest?

**=RANK(M2,M$2:M$14)**

Thanks!

 

[kkknie]

You could count the total number of entries, add one and subtract the ranking.

=COUNT(M$2:M$14)+1-RANK(M2,M$2:M$14)

K

 

[sailepaty]

Try,

=RANK(M2,M$2:M$14,1)