Inverse rank

S

SteveC

Hi, is there a way to rank data in Col A do return the inverse rank in Column
B? Thanks...


Col A Col B
33 3
55 4
26 1
32 2
78 5
 
B

Bernard Liengme

How about:
=1+COUNT($A$1:$A$5)-RANK(A1,$A$1:$A$5)
in B1 and copied down the column.
best wishes
 
R

RagDyeR

This will return your *present* ranking order as you copy down:

=RANK(A1,$A$1:$A$5,1)

This will return the inverse:

=RANK(A1,$A$1:$A$5)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi, is there a way to rank data in Col A do return the inverse rank in
Column
B? Thanks...


Col A Col B
33 3
55 4
26 1
32 2
78 5
 
S

SteveC

Assuming I have this formula to rank:

=SUMPRODUCT(--($A$13:$A$2651=$A13),--(AJ13<AJ$13:AJ$2651))+1

Where text labels are in Column A and data is in Column AJ -- this formula
assigns the largest number the highest rank (within the group as defined by
Col A)

What could we do to convert this formula to an inverse rank? I tried to use
Bernard's count formula to adjust, but couldn't figure it out.. .thanks a
lot...
 
S

SteveC

I figured it out, thanks:

=(SUMPRODUCT(--($A$13:$A$2651=$A139)))-(SUMPRODUCT(--($A$13:$A$2651=$A139),--(AJ139<AJ$13:AJ$2651))+1)
 
Top