software

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

In B1 enter:

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

and copy down
--
Gary's Studentquot;SteveCquot; wrote:

gt; Hi, is there a way to rank data in Col A do return the inverse rank in Column
gt; B? Thanks...
gt;
gt;
gt; Col A Col B
gt; 33 3
gt; 55 4
gt; 26 1
gt; 32 2
gt; 78 5

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

quot;SteveCquot; gt; wrote in message
...
gt; Hi, is there a way to rank data in Col A do return the inverse rank in
gt; Column
gt; B? Thanks...
gt;
gt;
gt; Col A Col B
gt; 33 3
gt; 55 4
gt; 26 1
gt; 32 2
gt; 78 5
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!
================================================== ===

quot;SteveCquot; gt; 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


quot;SteveCquot; wrote:

gt; Hi, is there a way to rank data in Col A do return the inverse rank in Column
gt; B? Thanks...
gt;
gt;
gt; Col A Col B
gt; 33 3
gt; 55 4
gt; 26 1
gt; 32 2
gt; 78 5

Assuming I have this formula to rank:

=SUMPRODUCT(--($A$13:$A$2651=$A13),--(AJ13lt;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...

I figured it out, thanks:

=(SUMPRODUCT(--($A$13:$A$2651=$A139)))-(SUMPRODUCT(--($A$13:$A$2651=$A139),--(AJ139lt;AJ$13:AJ$2651)) 1)