Inverse rank
 

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

Inverse rank
 

In B1 enter:

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

and copy down
--
Gary's Student


"SteveC" wrote:

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

Inverse rank
 

How about:
=1+COUNT($A$1:$A$5)-RANK(A1,$A$1:$A$5)
in B1 and copied down the column.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SteveC" wrote in message
...
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

Inverse rank
 

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

"SteveC" wrote in message
...
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

Thank you all
 

"SteveC" wrote:

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

Inverse Rank with Sumproduct
 

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

Inverse Rank with Sumproduct
 

I figured it out, thanks:

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