# Ranking 2

#### Harquor

##### New Member
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!

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### kkknie

##### Well-known Member
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

##### Active Member
Try,

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

Replies
8
Views
142
Replies
4
Views
127
Replies
5
Views
96
Replies
1
Views
87
Replies
3
Views
275

1,141,011
Messages
5,703,728
Members
421,311
Latest member
tanujath

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back