RANK without a tie

  • Thread starter Thread starter jane
  • Start date Start date
J

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
 
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)
 
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!
 
Back
Top