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