Hi,

I am using rank to find the winners in order in a competition, for those
that have not scored, how can I make the rank result blank. The lowest
score is the winner, hence the 1 at the end of the rank equation.

Have used these two examples:
=RANK(F7,$F$6:$F$43,1)
=IF(ISNA(RANK(F6,$F$6:$F$43,1)),"",(RANK(F6,$F$6:$ F$43,1)))

In my list $F$6:$F$43 there can be no results due to non starters in the
competiton, there could also be an S for scratched, E for eliminated, and R
for retired. The data in the range is a number relating to a percentage,
with the lowest percentage as the winner. I need to show the placings from
1st to last in the group with blanks, S, R & E not included in the rank. The
two equations I have used give #VALUE for any field that is not numeric.

I would greatly appreciate any help.

Regards,
Jenny

How about this

=IF(ISNUMBER(F6),(RANK(F6,$F$6:$F$43,1)),"")

--

HTH

Bob

"Jenny S" wrote in message
...
Hi,

I am using rank to find the winners in order in a competition, for those
that have not scored, how can I make the rank result blank. The lowest
score is the winner, hence the 1 at the end of the rank equation.

Have used these two examples:
=RANK(F7,$F$6:$F$43,1)
=IF(ISNA(RANK(F6,$F$6:$F$43,1)),"",(RANK(F6,$F$6:$ F$43,1)))

In my list $F$6:$F$43 there can be no results due to non starters in the
competiton, there could also be an S for scratched, E for eliminated,
and R
for retired. The data in the range is a number relating to a percentage,
with the lowest percentage as the winner. I need to show the placings from
1st to last in the group with blanks, S, R & E not included in the rank.
The
two equations I have used give #VALUE for any field that is not numeric.

I would greatly appreciate any help.

Regards,
Jenny

Hi Bob,

Thank you so much, this has done exactly what I needed.

Regards
Jenny

"Bob Phillips" wrote:

How about this

=IF(ISNUMBER(F6),(RANK(F6,$F$6:$F$43,1)),"")

--

HTH

Bob

"Jenny S" wrote in message
...
Hi,

I am using rank to find the winners in order in a competition, for those
that have not scored, how can I make the rank result blank. The lowest
score is the winner, hence the 1 at the end of the rank equation.

Have used these two examples:
=RANK(F7,$F$6:$F$43,1)
=IF(ISNA(RANK(F6,$F$6:$F$43,1)),"",(RANK(F6,$F$6:$ F$43,1)))

In my list $F$6:$F$43 there can be no results due to non starters in the
competiton, there could also be an S for scratched, E for eliminated,
and R
for retired. The data in the range is a number relating to a percentage,
with the lowest percentage as the winner. I need to show the placings from
1st to last in the group with blanks, S, R & E not included in the rank.
The
two equations I have used give #VALUE for any field that is not numeric.

I would greatly appreciate any help.

Regards,
Jenny



.