Inverse rank

[Guest]

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

 

[Guest]

In B1 enter:

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

and copy down

 

[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

 

[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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

I figured it out, thanks:

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