RANK without a tie
 

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

RANK without a tie
 

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)

"jane" wrote in message
...
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

RANK without a tie
 

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!

In article ,
jane wrote:

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

RANK without a tie
 

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

thank you! jane

"Bob Phillips" wrote:

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)

"jane" wrote in message
...
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