# Invert Ranking

#### dariuzthepole

##### Board Regular
Hi all,

I have a ranking system in place for properties, based on price. My current system produces the most expensive as #1, then they decrease as the rank increases.

Is there a method/function to invert this, so that the least expensive property is ranked as #1?

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

=rank(number, ref, order)

where number is the number whose rank you want to find;
ref is a reference to the range of numbers you want to rank against (non-numeric values in the range are ignored),
and order refers to the way you want to ranking to appear - 0 or blank for descending and a non-zero number for ascending.

So you would use 1
e.g.

=RANK(B2,B2:B10,1)

The formula
=Total properties - currentRank +1 will return the inverted ranking

Total properties can probably be calculated with a COUNTA, depending on how your data is layed out.

try this (change the range to match yours

lowest to highest
=RANK(E7,\$E\$7:\$E\$13,1)

highest to lowest
=RANK(E7,\$E\$7:\$E\$13,0)

Replies
0
Views
129
Replies
1
Views
132
Replies
21
Views
322
Replies
4
Views
92
Replies
2
Views
210

1,203,242
Messages
6,054,350
Members
444,718
Latest member
r0nster

### 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