Ranking 2

Harquor

New Member
Joined
Jun 22, 2006
Messages
36
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!
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

kkknie

Well-known Member
Joined
Apr 29, 2002
Messages
677
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top