RANK IN SEQUENCE
 

RANK function omits the next rank number in a series after each set of tied
scores. For instance, if a cluster of scores are "2", the next ranking will
be 4 instead of 3. I want the rankings to show the next number in the rank
sequence and not to skip it. Is there a formula or a function which will
allow this?

RANK IN SEQUENCE
 

With the numbers in A2:A11

This will also account for empty cells:

=IF(A2="","",SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11&""))+1)

Copy down as needed

If there won't be any empty cells:

=SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11))+1

Biff

"Douglas Eckert" wrote in message
...
RANK function omits the next rank number in a series after each set of
tied
scores. For instance, if a cluster of scores are "2", the next ranking
will
be 4 instead of 3. I want the rankings to show the next number in the
rank
sequence and not to skip it. Is there a formula or a function which will
allow this?

RANK IN SEQUENCE
 

http://www.cpearson.com/excel/rank.htm


--
Regards,

Peo Sjoblom



"Douglas Eckert" wrote in message
...
RANK function omits the next rank number in a series after each set of
tied
scores. For instance, if a cluster of scores are "2", the next ranking
will
be 4 instead of 3. I want the rankings to show the next number in the
rank
sequence and not to skip it. Is there a formula or a function which will
allow this?

RANK IN SEQUENCE
 

Thank you VERY MUCH, Biff! That was beautiful!

"T. Valko" wrote:

With the numbers in A2:A11

This will also account for empty cells:

=IF(A2="","",SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11&""))+1)

Copy down as needed

If there won't be any empty cells:

=SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11))+1

Biff

"Douglas Eckert" wrote in message
...
RANK function omits the next rank number in a series after each set of
tied
scores. For instance, if a cluster of scores are "2", the next ranking
will
be 4 instead of 3. I want the rankings to show the next number in the
rank
sequence and not to skip it. Is there a formula or a function which will
allow this?

RANK IN SEQUENCE
 

You're welcome. Thanks for the feedback!

Biff

"Douglas Eckert" wrote in message
...
Thank you VERY MUCH, Biff! That was beautiful!

"T. Valko" wrote:

With the numbers in A2:A11

This will also account for empty cells:

=IF(A2="","",SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11&""))+1)

Copy down as needed

If there won't be any empty cells:

=SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11))+1

Biff

"Douglas Eckert" wrote in
message
...
RANK function omits the next rank number in a series after each set of
tied
scores. For instance, if a cluster of scores are "2", the next ranking
will
be 4 instead of 3. I want the rankings to show the next number in the
rank
sequence and not to skip it. Is there a formula or a function which
will
allow this?

RANK IN SEQUENCE
 

Thank you!

"Peo Sjoblom" wrote:

http://www.cpearson.com/excel/rank.htm


--
Regards,

Peo Sjoblom



"Douglas Eckert" wrote in message
...
RANK function omits the next rank number in a series after each set of
tied
scores. For instance, if a cluster of scores are "2", the next ranking
will
be 4 instead of 3. I want the rankings to show the next number in the
rank
sequence and not to skip it. Is there a formula or a function which will
allow this?