RANK without a tie

[jane]

The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2.

The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0

This is the formula I used to get rid of the tie but it is not working -
=RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then
copies to N2, etc.


please help... thanks! jane

 

[Bob Phillips]

Why aren't you using

=RANK(K2,$K$2:$AL$2)+(COUNTIF($K$2:K$2,K2))-1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Domenic]

Assuming that the cells between the target cells do not contain
numerical values, try...

K2, copied across:

=IF(K2<>"",RANK(K2,$K$2:$AL$2)+COUNTIF($K$2:K2,K2)-1,"")

Hope this helps!

 

[jane]

ah Bob,
you always come up with the right solution!

thank you! jane