In cell H3:
=RANK(A3,$A3:$D3,1)
and fill to the right until column K!
Regards,
Stefi
€žwhodey€ť ezt Ă*rta:
I read that post and it sounded confusing. Here's the goal:
A3= 9
B3= 15
C3= 25
D3= 4
How can I get Excel to show:
H3= 2 (2 assigned to the 3rd number in the group)
I3= 3 (3 assigned to the 2nd highest value in the group)
J3= 4 (4 assigned to the highest value in the group)
K3= 1 (1 assigned to the lowest value in the group)
I don't believe an IF statement can accomplish this as I've tried a
million different ways with no luck. Again, I appreciate any help that
can be provided. Thanks.
--
whodey
------------------------------------------------------------------------
whodey's Profile: http://www.excelforum.com/member.php...o&userid=29596
View this thread: http://www.excelforum.com/showthread...hreadid=492977