Invert Ranking

[dariuzthepole]

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?

 

[shyrath]

see the other reply

=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)

 

[mikerickson]

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.

 

[texasalynn]

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)